cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
efilipe Member
Member

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 Organizati... (for Office 365 or OneDrive for Business sites).

O
nedrive 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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Use OneDrive links in Power BI Desktop

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Use OneDrive links in Power BI Desktop

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.