The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
20 | |
19 | |
17 | |
13 |