Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to change the Data source connection from 'SQL Server database' to 'Azure SQL Server database'

Hi,   I need a help regarding changing of data source connection from SQL Server database to Azure SQL Server database. Litte background, I have created a Power BI report using the 'SQL Server data...
Need Help
Show and Tell
Tips and Tricks
SNawalKishore1's avatar
SNawalKishore1
Regular Visitor
7 years ago

Hello Anonymous ,

 

 

I hope this will help you.

 

 

Step 1. Create new AzureDB.PBIX with Azure SQL DB Connection.

Step 2. Open SQLDB.PBIX with On-Prem SQL Server DB Connection, then go to Edit Query > Advance Editor and copy all Applied Steps "Except" Source (which is on-prem sql server).

Step 3. Go to AzureDB.PBIX, then go to Edit Query > Advance Editor paste all steps "Except" Source(which is New Azure SQL DB).

Step 4. Repeat Step 2 & Step 3 until all tables replaced with Applied steps.

 

Step 5. Then switch back to old PBIX, copy the all visuals from SQLDB.PBIX and Paste to AzureDB.PBIX as all the Tables & Column Names are identical.

 

Please try and let me know.

 

Cheers,

Nawal
+91-9866755720 | Power BI Consultant

https://www.linkedin.com/in/snawalkishore/

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Nawal, I appreciate your continues help on this issue. As per you steps below, It's working partially that means I able to copy the visuals from one report to another report - which is really a good thing, but I have to create the 'Measures' once again on the Azure connection report. 

     

    Thanks!!