Changing Data Source of Transform Sample File

---

danandrew17 wrote:

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 Transform Sample File I am getting the following error:

 

Expression.Error: We cannot convert a value of type Table to type Binary.
Details:
Value=Table
Type=Type

 

I'm not an advanced developer but I'm surprised to get an error message because the new source file is identical to the original and there is simply a change in the name of a folder in the file path.

 

Hopefully somebody can help me understand how to address this.

 

Thanks,

Dan

---

I know this is probably too late but I found a solution and I hope this can help those who come across this later on. Somehow when I changed data source, my sample file's data source location didn't change with it. Which is why I had the same error.

Solution:

Go to Query Editor, click on your sample file on the query list.

On the 'Applied Steps' pane on the right side, the first step is 'Source', make sure your Source's setting is corrected to your new source location.

The second step in that same pane is 'Navigation', if you click the setting in that you'll see the folder is corrected now, but the file it's set to navigate to is still the old location. This is what needs to be fixed.

Go back to 'Source' in the Applied Steps, on the query table you'll see your sample file on the first row, now click "Binary" on column 1 on your sample file row. A new step will be created in the 'Applied Steps' - we don't need this, just delete that new step. Now you'll see the file path has been fixed in the 'Navigation' setting to the new source location.