Forum Discussion
How to replace Data Source for existing report?
Anonymous In power bi desktop go to query editor, select your table and on the right hand side under Applied Steps click settings icon. You can also without going to query editor - go to File -> Options and settings -> Data source settings >Right click data sources and chnage source.
go into Edit Queries. Find the table/query you want to change. Go to the first step in the Query (always called Source) and change it there.
Anonymous In power bi desktop go to query editor, select your table and on the right hand side under Applied Steps click settings icon. You can also without going to query editor - go to File -> Options and settings -> Data source settings >Right click data sources and chnage source.
the "change source" is grey for me.
Grey for me as well, I don't think this should be marked as "Solved".
Hi.
I am trying to change my source from local tsv to a url tsv.
I see in editing source i can change the file but it seems I'm not able to change to a URL (as I am able in the initial get data window).
*not able to download too large for HD
*Recreating the query and subsequent table edits would be .. not ideal.
= really hoping to seamlessly point the existing steps + report to a URL source instead of current local file upload:)
Did you find a solution for your issue ? I'm trying to edit the source from a TEST environment Odata source to a PROD environment Odata.
Hi All,
How to update an existing powerBI report when the datasource changes from DEV to TEST ?
Hi Ankit. There's a detail I want to confirm. I have 8 different tables in my report, all of which have storage mode as DirectQuery. So my question is - if I change the Data source using File Menu --> Data Source Settings, will the change apply to ALL the DirectQueries ?
P.S. : If it helps, I am simply trying to change the source DB from UAT to Production.
