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 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!
Super UserHI 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!