Forum Discussion

Reimer's avatar
Reimer
Helper II
6 years ago
Solved

Datasource error

Hi all,

 

A collegue of mine moved a excel file which is a data source for Power BI. How do I let Power BI know what the new location of the file is?

 

Regards,

 

  • Open the Power Query Editor (Transform data). Click on the gear icon next to the Source step for the query in question. Update the file location.

  • Reimer ,

    1. Under data Transformation, you have edit Date source you have the location.

    2. Open data transformation, right-click on table open advance editor, You have excel/table location 

     

2 Replies

Replies have been turned off for this discussion
  • Reimer ,

    1. Under data Transformation, you have edit Date source you have the location.

    2. Open data transformation, right-click on table open advance editor, You have excel/table location 

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Open the Power Query Editor (Transform data). Click on the gear icon next to the Source step for the query in question. Update the file location.