Forum Discussion
Live connection to SSAS model + oracle dataset
I have a power bi report where i am pulling live connection from an ssas tabular model
I want to pull in another dataset (from oracle) into the same report, but when I het Get data I cannot select another source
I want to pull another table from oracle, or atleast write a sql query to add as a dataset (oracle source) , can I do that ?
Hi Anonymous ,
Sorry, for live connection to ssas data source, you can only connect to a single data source. You can no longer connect to the oracle source, if you must connect to multiple data sources, you can try other connection modes.
Here is an introduction to official documents, which can be used as a reference: Connect to Analysis Services tabular data in Power BI Desktop - Power BI | Microsoft Docs
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Syndicate_AdminAdministrator
Good afternoon, I have the same drawback, did you manage to add another origin?
v-henryk-mstfCommunity Support
Hi Anonymous ,
Sorry, for live connection to ssas data source, you can only connect to a single data source. You can no longer connect to the oracle source, if you must connect to multiple data sources, you can try other connection modes.
Here is an introduction to official documents, which can be used as a reference: Connect to Analysis Services tabular data in Power BI Desktop - Power BI | Microsoft Docs
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.