Forum Discussion
Change data source from SQL Server Analysis Services Database to Power BI Datasets
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!
Thank you for the quick response. The content in the Power BI dataset is identical to the content in the tabular model in the SSAS database. We're doing this test because we're planning to move our data model from SSAS to Power BI. I've confirmed that copy and paste works since everything is the same, but I do wonder if there is an easier way. Thank you again!
HI Anonymous ,
If it is truly identical, you can open the report you have with SQL, then do a save as so you have a copy. Then, go to files- options and settings - data settings. Then, select the datasource that you have now and replace it with the new one. That is how we do it when we convert from a DEV to PROD system so we don't have to copy/paste!
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!
Thank you again!
Right, that is also what we do to convert from dev to prod. However, since the report is connected to a 'SQL Server Analysis Services Database', when I go to Files>Options and settings>data source settings, it gives me this window to change to a different ssas database:
I can only change it to a different SSAS database. It doesn't allow me to connect using the Power BI dataset option. Can I change what I see here?
Thanks!
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!
Thank you again!
What did you end up doing in this case?
