Unable to refresh data from power bi desktop

[shanghuanzhao]

Hello there, 

I'm working with Power BI desktop, the excel file is stored in company's one drive.

after established all relationship in different tables and worked with dashboard.

it tells me, one of the file "access to the resource is forbidden" and other files "load was cancelled by an error in loading previous table" . see attached photo.

can anyone advise a solution, please?

thank you

Shanghuan

[v-yuta-msft · Accepted solution]

@shanghuanzhao ,

This issue should be caused by incorrent login option, please follow steps in this documentation about how to connect to excel file on onedrive using web connector.

Community Support Team _ Jimmy Tao

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

[shanghuanzhao]