Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

lost data source link

Hi,

 

My company has changed the IT server anmes and now my PowerBI report can't find the file (Excel) any more, even when the source file folder name did not change. And as such one table in the middle of the data link overview then disappeared and my reports vanished. Can anybody held how I change the location BEFORE I accept the changes powerBI wants me to accept?

 

Thanks for any hint.

 

Ragrds,

Matthias

Need Help

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I would also recommend to use parameters in your connections to easily face this kind of scenarios.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

         

        Thanks for the hint. Would you be able to point to an faq article on how to do that? Thanks a lot.

        Regards, Matthias

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      I did that and than the reports vanished. I would need to change the pointer to the file location without changing the fiel name (even if its the same) as it appears this makes the relevant table in the file disappear from the link overview and then I would have to build it up again.

       

      Regards,

      Matthias

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        6 years ago

        Hi , Anonymous 

        I will reproduce your situation for your reference if I understand you correctly.

         

        Before:  excel file location ( On the computer desktop):

        After : move the excel from desktop to another folder  

        Then it will show error when enter into  edit queries or refresh as below:

         

        So please try steps as below :

         

         

         

         

         

         

        PS.  make sure you have not changed the data structure in excel, otherwise it is easy to cause the report content to be wrong or missing

         

        Best Regards,
        Community Support Team _ Eason

         

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi , Anonymous 

    Could you please tell me whether your problem has been solved?
    If it is,  please mark the helpful replies or your reply as Answered to close this thread?

     

    Best Regards,
    Community Support Team _ Eason