Forum Discussion

Simon_Br's avatar
Simon_Br
Helper I
2 years ago

Excel Data Source

Hello,

 

for one Power BI Story we used a Excel-Table and thies file is saved on SharePoint. Now the Problem is, another user have Problem with the Link to the Excel and must everytime edit the link.
Why is that so? 

Is there a setting to ensure that the path is always correct? As the Excel table is on the SharePoint, the path should not change.

But why does this not work? Do you have any ideas?

 

BG

Simon

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Simon_Br 

     

    First, to confirm what you are experiencing: your excel is on SharePoint and the user needs to re-edit credentials every time he connects to SharePoint from Power BI. If I understand correctly, you can try to get the user who is having the problem into PowerBI Desktop and clear the permissions in the location shown here.

     

    File -> Options and setting - > Data source settings

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.