Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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 _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@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
Can I use Direct Query for SQL Server and Live connection for SSAS ?
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 _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |