Issue with credential on shared OneDrive file

[dpuzio]

Hello,

I created a report for which datasource is a shared me excel file from onedrive. After publishing the report I was not able to resfresh it due to lack of credential but if I tried to add it some error occured that "the OAuth authentication method is not supported for this data source". Of course other methods not worked too.

Is there a chance to refresh that kind of file? Please help.

Below desctription of error if it helps but labels are in polish.

Identyfikator działania:	6402af7b-defb-43b5-b167-fbea83f10468
Identyfikator żądania:	e981a337-6489-cb05-cc5f-95018686a7a6
Kod stanu:	400
Godzina:	Thu Feb 23 2023 19:09:54 GMT+0100 (czas środkowoeuropejski standardowy)
Wersja usługi:	13.0.20105.47
Wersja klienta:	2302.2.12402-train
Identyfikator URI klastra:	https://wabi-north-europe-e-primary-redirect.analysis.windows.net/

[dpuzio]

Thanks a lot! It's working. I had wrong way of getting the link for file.

[GilbertQ · Accepted solution]

Hi @dpuzio 

How did you connect to the OneDrive file, is it a local OneDrive file on your PC or did you connect to OneDrive online?

Here are details on how to connect Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn