Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
@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,
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.