Excel Data Source

[Simon_Br]

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

[Anonymous]

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.