Forum Discussion

Franky_Piferoen's avatar
Franky_Piferoen
Frequent Visitor
9 years ago
Solved

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 rep...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    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,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
Franky_Piferoen
Frequent Visitor
9 years ago

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.