Forum Discussion
use multiple Data source in one pbix file SQL Server and SSAS
My main goal is the compare the enterprise Data in SQL Server with the Data in SSAS that I develop to facilitate the compare the quality of the data calculated and the original values.
So I m looking for a way to automatize this process instead of developing the report using SSAS and giving it to end-users to compare with the data in SQL Server, I wanna combine those Data in one power BI file to gain time
Can I combine those two sources of Data SQL Server and SSAS in one file or there is another manner to achieve this goal?
I'll be glad if someone can help me
Hi Anonymous ,
You can't use Direct Query for SQL Server and Live connection for SSAS. For live connection mode, you cannot explore live data and connect to another type of data source in the same file. When you try to do it, you will get the below disable warning.
So as amitchandak suggests, if you want to connect to SQL Server and SSAS at the same time, you should use import mode.
For more details, please refer to the documentation: DirectQuery, Live Connection or Import Data? Tough Decision!
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , Connect both SQL server and SSAS in import mode and them create data comparison
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data
Hi Anonymous ,
You can't use Direct Query for SQL Server and Live connection for SSAS. For live connection mode, you cannot explore live data and connect to another type of data source in the same file. When you try to do it, you will get the below disable warning.
So as amitchandak suggests, if you want to connect to SQL Server and SSAS at the same time, you should use import mode.
For more details, please refer to the documentation: DirectQuery, Live Connection or Import Data? Tough Decision!
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
