Forum Discussion
Need to change SQL in data source
shelbsassy So first, cut a copy of your desktop PBIX file and save it as a seperate file. Use that file to mess around with so you aren't so worried about destroying your report.
You can easily access the original query by going to edit queries and clicking on the wheel icon next to the "Source" in the Applied Steps pane on the right hand side. This will open the original prompt and you can copy/paste the new code in there.
As long as the new query includes the columns you are already using you shouldn't have any issues with things breaking. You would do this for each query you have, as each would have their own SQL code I assume. (If you have multiple queries and you are worried about relationships breaking)
shelbsassy So first, cut a copy of your desktop PBIX file and save it as a seperate file. Use that file to mess around with so you aren't so worried about destroying your report.
You can easily access the original query by going to edit queries and clicking on the wheel icon next to the "Source" in the Applied Steps pane on the right hand side. This will open the original prompt and you can copy/paste the new code in there.
As long as the new query includes the columns you are already using you shouldn't have any issues with things breaking. You would do this for each query you have, as each would have their own SQL code I assume. (If you have multiple queries and you are worried about relationships breaking)
Anonymous Thank you for your reply! Just what I needed! Saved me a lot of work!