Solved: Changing data source after publishing

Milkman · ‎07-15-2019

Good morning,

i'm trying to discover if there is the possibility to change data source after publishing report to PowerBi web.
I'm developing Power BI reports locally connecting to a localhost database (i cannot connect to the remote database due to security), after publishing the report i need to change the data source connection to the remote database but i cannot see where i can change this.

Do you have any hint?

Thank you

v-frfei-msft · ‎07-15-2019

Hi @Milkman ,

We cannot change data source in power bi service. We can change it in power query as @Tahreem24 said and republish the report to service.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Tahreem24 · ‎07-15-2019

Hi @Milkman ,

You can change it through Advanced Editor in Power Query. For more details please visit the below URL posted by @zzsuffa.

https://www.decisivedata.net/blog/change-a-power-bi-data-source-type

Hope it will help you.

If you find this helpful so please mark this as a solution.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

v-frfei-msft · ‎07-15-2019

Hi @Milkman ,

We cannot change data source in power bi service. We can change it in power query as @Tahreem24 said and republish the report to service.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.