Forum Discussion
Changing Data Source of Transform Sample File
Hello, I moved the source data of a PBI report and I had to change the file path source of my queries. This worked fine for the data tables but when I tried to change the file path source for the T...
This isn't a perfect answer but it worked for me. I opened a new PBI file, created a revised query with the new source. I renamed the helper quries, sample files, tranform file, and group to unique names. I highlighted just the helper queries, right clicked and selected copy, and pasted the helper files into the existing PBI file. Then I opened the advanced editor on the query in the new PBI file and copied and pasted it into the query of the PBI file I wanted it in. It saved me from having to start from scratch.