Forum Discussion

fabienzan's avatar
fabienzan
New Member
8 years ago
Solved

PowerBI chainging source

. We have a PowerBI report pointing to Excel all working well. We won't to re use the layout and repoint to a different spreadsheet which as the same structure as the original one. Would you know how to do that ?

 
Need Help
Show and Tell

5 Replies

  • theitguy's avatar
    theitguy
    Helper I
    8 years ago

    You want to change the path of the source to repoint to another spredsheet?

    If yes, go to Main Page, Tab "Home", choose "Edit Queries", select the query for which you want to change the source. Then click on settings icon of the transformation step called "Source". Here you can change the path.

    • fabienzan's avatar
      fabienzan
      New Member
      8 years ago

      I tried to do that but it doesn't refresh with the new data.

       

      My email is [email protected] . Happy to do a teamViewer about if you have 5 mns

      • theitguy's avatar
        theitguy
        Helper I
        8 years ago

        Hi fabien,

        unfortunately, I am not available for TeamViewer right now...

        Have you tried the Refresh-Button as well?