Forum Discussion
Converting from SQL Azure DB connections to Azure Analysis Service
All of our existing PBI Reports are based on direct SQL Azure DB connections. Is there a way of switching these over to use Azure Analysis Service without having to recreate every report from scratc...
Hi mbhunt,
You can create a new .pbix file to get data from Azure Analysis Services database, check if retrieved tables and contained fields are the exactly same as when you retrieve from the SQL Server database. If it is the same, then you can copy the Power Query in this new .pbix to replace Power Query in original report. If not, then it's not possible to change data source and keep the report display.
Besides, we are not able to copy the reports from on .pbix file to another currently.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft,
Can you please tell me how "you can copy the Power Query in this new .pbix to replace Power Query in original report."?
Thanks much,
Matt