Use OneDrive links in Power BI Desktop

[efilipe]

Im trying to connect OneDrive with PowerBI. This instruction looks well, but it doesnt work for "personal" OneDrive:

Desktop prompts you for credentials, choose either Windows (for on-premises SharePoint sites) or Organizati... (for Office 365 or OneDrive for Business sites).

Onedrive doesnt have, for example, the "?web=1". Also it doesnt have the name of the file, but a link like:

https://1drv.ms/x/s!AmKfadshkj3hE#GE

Any ideas?

[v-qiuyu-msft · Accepted solution]

Hi @efilipe,

Assume the Excel stored in personal OneDrive, you need to use this kind of the URL format:

https://onedrive.live.com/download?resid=AAXXXX&authkey=AAXXXXXXX&em=x&app=Excel

Then use it in Web data source. For detail information, see: PowerBI support for OneDrive Personal as data source.

Best Regards,
Qiuyun Yu