Change spreadsheet import to an Azure SQL Database

[mikegray]

Hi,

I am currently changing existing Power BI reports for a client.  The reports retrieve data from on premise SQL Server Databases and spreadsheets.  I have worked on a project where we have moved the SQL Server DB to the Azure cloud and Azure SQL Database.  I am going to repoint the reports to Azure SQL databases.  The client want the spreadsheet data to be migrated to the Azure SQL database which I am in the process of completing.

The query I have relates to how easy it is the re-point the Spreadsheet imports to Azure SQL Database.  Does Power BI manage this if I can re-point or do I need to remove the spreadsheet import and all the applied changes and re-create with a new import to Azure SQL.  Will this mean I will need to re-create all the necessary changes.  The schema will be the same as the spreadsheet on the database.

Thanks

Mike

[v-xicai · Accepted solution]

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.

[mikegray]

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