Change data source from SQL Server Analysis Services Database to Power BI Datasets

This is pretty ridiculous. SO you can repoint nearly every other data source to a different data source by going into power query or get data but you can't repoint an on premise Analysis Services cube to an identical Power BI dataset without "Copying and pasting"...just poor.

This works for Semantic Models in March 2024:

• Create a new empty report to serve as the connection source:

1. Home -> New -> Report
2. Connect to the desired semantic model
3. 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.

Hi Anonymous ,

Unless the Power BI dataset is identical to the SQL Server Analysis Services Database, you will have to get new connections.  BUT, you stated that you are using a dataset and not a "different SQL Server" so that sounds to me like you have a totally different connection and datasource and so you will have to rebuild everything.  In that case, copy and paste visuals won't work either if your data sources in the dataset are different.

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!

For those coming here in 2024 or later, I figured out an easy solution to remove the current connection to AAS/SSAS:

1. At the bottom of PBI Desktop it states: Live Connection: Connected Make changes to this model

2. Click 'Make changes to this model'
3. Click 'Add a local model'

4. Click 'Submit'. A Direct Query connection will now be made.
5. Go to Transform Data > Data source settings

6. Select the DirectQuery to AS source and either hit the trashcan on the right or rightclick > delete. Confirm Delete.

7. Hit 'Apply Changes' in the bar that pops up above. There is now no data source whatsoever

8. Go to Get Data > Power BI semantic models

9. Choose a semantic model and connect

1.deploy blank power bi connected to semantic model to your workspace
2.change blank power bi file extension from ".pbix" to ".zip"
3.unzip the ".zip" file during this process (in the zip file > Extract All)
4.go back to your SSAS connected power bi report, Change the extension from ".pbix" to ".zip"
5.unzip the ".zip" file during this process (in the zip file > Extract All)
6.copy and paste 'Connection' file conents from blank to your power bi report connection file
7.Delete "SecurityBindings" file in the ".zip" file from your power bi zip where you have all your visuals
8.open [Contents_type].xml with notepad and delete: "<Override PartName="/SecurityBindings" ContentType="" />" in power bi report with visuals
9.save and close
10.zip all items in the modified folder with new name
11.Change the extension from ".zip" to ".pbix"
The file will open without breaks