Forum Discussion

seanpratt's avatar
seanpratt
Helper III
6 years ago

Change Source Unavailable for Excel File

Oh lord, what have I done? I created a Power BI dashboard using a long excel file for survey responses. However, I only used the data to connect to and built my dozens of measures within Power BI and not in a PowerPivot. Now, I want to send my finished dashboard and Excel file to my colleague and say "Here's what to do, every month update the Excel file and click refresh blah blah". However, part of this speech I give to colleagues or clients includes the classic "Change the source by doing this..." 

However with this dashboard I don't have that option! Why does this happen and what can I do to resolve this? I'm worried I may have to recreate the dashboard again but then still unsure on how to prevent this from happening again.

 

Any support on how to save this dashboard and allow for data source changing would be gratefully received!

Need Help

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Worst case you should be able to use the Query Editor to just change the Source step either through the gear icon or Advanced Editor.

    • seanpratt's avatar
      seanpratt
      Helper III
      6 years ago

      The icon doesn't exist beside 'Source' (again never seen that) and I instructed my colleague to use the Advanced Editor trick and he claimed it didn't work. 

      Any other suggestions, or maybe tips on why this happens so I can avoid it happening again?

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago

        Any way that you could copy and paste the code from Advanced Editor? Or are you not allowed in Advanced Editor?