Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • collinq's avatar
    collinq
    5 years ago

    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!

Nik_report_dev's avatar
Nik_report_dev
New Member
1 year ago

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