Forum Discussion

danandrew17's avatar
danandrew17
New Member
7 years ago

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...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi danandrew17 ,

 

We can just click the source step to change the file path of your sample file.

 

 

  • danandrew17's avatar
    danandrew17
    New Member
    7 years ago

    Hello and thank you for the response, the trouble is that when I change the source path of the Sample File, the 'Transform Sample File' step encounters this error message:

     

    An error occurred in the ‘Sample File’ query. Expression.Error: The key didn't match any rows in the table.
    Details:
        Key=Record
        Table=Table

     

     

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi danandrew17 ,

       

      Are the tables are in the same format for your old and new files?

       

      • danandrew17's avatar
        danandrew17
        New Member
        7 years ago

        Hello, they are identical.  I literally created a duplicate of all the source files so the only difference is a slight change in a folder name.

         

        Dan