Forum Discussion
Change spreadsheet import to an Azure SQL Database
Hi mikegray ,
You may go to Query editor, select on this query, right click to open Advanced Editor , you will see the connection information like below:
You may replace this with Azure SQL connection information. You can just create a new report, get data from the Azure SQL database, copy this information from Advanced Editor then replace the original report connection information.
If the Azure database content is the same as original database, the difference is just the move to Azure. It will not affect measures and visuals as data are not changed. So there is no need to re-create all the necessary changes.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mikegray ,
You may go to Query editor, select on this query, right click to open Advanced Editor , you will see the connection information like below:
You may replace this with Azure SQL connection information. You can just create a new report, get data from the Azure SQL database, copy this information from Advanced Editor then replace the original report connection information.
If the Azure database content is the same as original database, the difference is just the move to Azure. It will not affect measures and visuals as data are not changed. So there is no need to re-create all the necessary changes.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Amy,
Many thanks for your solution. I intend to try this once I have the spreadsheets uploaded to DB. I will let you know the outcome.
Thanks
Mike