Forum Discussion
Change data source from SQL Server Analysis Services Database to Power BI Datasets
Hi, I have reports that have a live connection to a tabular model on SQL Server Analysis Services Database, and now I want to change the data source to use Power BI datasets. These reports have a lot...
HI Anonymous ,
No, connecting to the dataset and then copy/paste is going to be your best bet.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
This works for Semantic Models in March 2024:
- Create a new empty report to serve as the connection source:
- Home -> New -> Report
- Connect to the desired semantic model
- Save the report as source.pbix
- Create a copy of the SSAS .pbix file. Let’s call this Destination.pbix
- Make sure Destination.pbix is not ready only (in widnows, right click -> Properties ->Attributes).
- Rename Destination.pbix by changing the extension from .pbix to .zip.
Note: If you are on Windows, you will need to have the “File name extensions” checkbox checked in Windows Explorer as shown below:
- Rename the source.pbix by changing the extension from .pbix to .zip.
- Use Beyond Compare to compare the two .zip files and copy over the contents of the “Connections” file from source.pbix to the other file.
- Rename the resulting file from step 6 by changing the extension from .zip to .pbix.
- When you open the converted file, you might notice that the hidden tables and hidden measures are being shown. Right click on one of these tables and uncheck the “View Hidden” option. The visibility settings for all tables and measures will now work as expected.
Superb. Thanks for sharing 👏