Re-link Onedrive Excel with Power Bi online dataset

[cnitscher]

Hi all,

I have a Power bi online report that was unlinked with the OneDrive Excel sheet. The file has the same name and is in the same folder, but for some reason, the dataset doesn´t find the file, so it can't be refreshed.

Is there any way to reconnect it?

Thank you very much

Claudio

[v-diye-msft]

Hi @cnitscher 

You might try to remove the dataset and reconnect it, here's an article for your reference:

https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive 

[cnitscher]

Hi,
If I try to remove the dataset, power bi alerts me that it will remove the reports that are associated. And I will have to setup those reports again.

[GilbertQ]

Hi there

You would need to go into the Excel file, find the link and use that as the data source in your PBIX

Here is a link on another way to complete it: https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

[cnitscher]

Hi, thank you for your answer!

My Power Bi Panel was made online and not with Power Bi desktop, so what I need is to make that link in the web environment and not through PowerBi desktop.

Is there any way to do that?

Regards

Claudio