Forum Discussion
Change datasource after publish from on premise to azure sql db
I've created some reports, for which I used an on premise sql server as datasource (Import).
I used parameters to define the sqlserverInstanceName and DatabaseName.
I can publish and use these reports on app.powerbi.com.
But now I would like to schedule a refresch in app.powerbi.com and get the data from an Azure Sql DB.
Is this possible, or do I have to use Azure SQL DB as a source in power bi desktop before I publish my reports ?
Franky_Piferoen,
It is not possible to change data source in Power BI Service.In Power BI Desktop, create a query that connects to Azure SQL database, then go into Query Editor and go to Advanced Editor, copy Source line. Go to SQL database query in Query Editor, Advanced Editor and replace the Source line. After that, publish your Power BI Desktop file to Power BI Service.
Regards,
2 Replies
Franky_Piferoen,
It is not possible to change data source in Power BI Service.In Power BI Desktop, create a query that connects to Azure SQL database, then go into Query Editor and go to Advanced Editor, copy Source line. Go to SQL database query in Query Editor, Advanced Editor and replace the Source line. After that, publish your Power BI Desktop file to Power BI Service.
Regards,Hi,
thx for the answer. I had already changed the data source in power bi desktop by changing my parameter 'SqlServerInstanceName' to the url of the azure sql db and published the reports.
This works, but I am missing the functionality to use the parameters to change the connection after the reports are published in app.powerbi.com.I import a rather large amount of data, which works much faster if i can import these from my on premise sql server while developing.
