Forum Discussion
How to change the Data source connection from 'SQL Server database' to 'Azure SQL Server database'
Hello Anonymous ,
Very Simple.
Open Power BI Desktop > Open Edit query > Left side in Queries Pane> any table > Right side in Applied Steps > Double click on Source > Change Server name and database name and Click OK.
Cheers,
Nawal
+91-9866755720 | Power BI Consultant
Thank you! Kishore, for your reply. I did that, but as per my testing, the way the connectors work seems like different because when you select 'SQL Server database' as your source at the first step and you deploy the report to service you can schedule the 'data set' through the gateway. But, if you select the 'Azure SQL Server' database at the first step by default it will automatically refresh every 1 hour on the Power BI service because I selected the 'Azure SQL Server' as my connector at the very first step. So, if you change the database name it will work but it won't bring the properties of the 'Azure SQL Server' like 'Cache' dataset refresh, I'm looking for changing the 'SQL Server database' to 'Azure SQL Server' at the very first step.
Thanks!!