Forum Discussion

vinaypugalia's avatar
vinaypugalia
Resolver I
9 years ago
Solved

Change the data source from on premise SQL Server to SQL Azure | What should be taken care of?

Hello,   I have developed Power BI reports using Local SQL Server and now the client wants to move the database to SQL Azure. Can someone please guide what care should be taken for this move and w...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi vinaypugalia,

     

    Sorry for the late response.

     

    1.The generally followed way to change the datasource from on-premise SQL to SQL Azure in Power BI.

     

    The way suggested in my original post is general method to change data source. We need to change it in Power BI Desktop. We can open Advanced Editor in Query Editor, you will see the connection information like below:

     

     

    You can replace this with Azure SQL connection information. You can create a new report, get data from the Azure SQL database, copy this information from Advanced Editor then replace the original report connection information.


    2.What will be the impact of this change on my measures & visuals?

     

    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.

     

    Best Regards,
    Qiuyun Yu

vinaypugalia's avatar
vinaypugalia
Resolver I
9 years ago

Thanks for sharing this information.

 

Also, can you please let me know the following - 

  1. The generally followed way to change the datasource from on-premise SQL to SQL Azure in Power BI.
  2. What will be the impact of this change on my measures & visuals?

Thanks!

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi vinaypugalia,

 

Sorry for the late response.

 

1.The generally followed way to change the datasource from on-premise SQL to SQL Azure in Power BI.

 

The way suggested in my original post is general method to change data source. We need to change it in Power BI Desktop. We can open Advanced Editor in Query Editor, you will see the connection information like below:

 

 

You can replace this with Azure SQL connection information. You can create a new report, get data from the Azure SQL database, copy this information from Advanced Editor then replace the original report connection information.


2.What will be the impact of this change on my measures & visuals?

 

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.

 

Best Regards,
Qiuyun Yu