Forum Discussion
Use OneDrive links in Power BI Desktop
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 Organizational Account (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?
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
1 Reply
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