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.
Hello everyone.
I've created a report in Power BI desktop which uses a live connection on a SSAS multidimensional cube.
Now I have to migrate this cube to Azure Analysis Services, which implies porting the cube to a newly created Tabular Model (which will mantain the original names for the columns and measures), and then I should change the report source to this Tabular.
My question is: is there a chance to get all the visuals of the report working without changes or do I have to rebuild the report?
Solved! Go to Solution.
Hi @Anonymous,
I would suggest you make a copy of your file first in case of failure and then try to change the source. Please refer to the snapshot below. Since it's a live connection, the Advanced Editor isn't available. But Greg's idea is very good for other similar scenarios.
Best Regards,
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Hello,
I'm facing the same problem.
Did you found a solution ?
Thank you for your help
Hi @Anonymous,
I would suggest you make a copy of your file first in case of failure and then try to change the source. Please refer to the snapshot below. Since it's a live connection, the Advanced Editor isn't available. But Greg's idea is very good for other similar scenarios.
Best Regards,
It's potentially possible. The general process is to create a new PBIX that connects to your new model. Copy the M code used to connect and use that code to replace the M code in your existing query. You do this using Advanced Editor in Power Query.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |