Forum Discussion

hugoventurini's avatar
hugoventurini
Icon for Advocate IV rankAdvocate IV
8 years ago
Solved

Connect Power BI Desktop to file folder on OneDrive for Business

Hello; I need to connect the Power Bi desktop to a file folder in OneDrive for Business, similarly to a file folder located in the c directory of any computer, and then write the data extraction rou...
Need Help
henry0513's avatar
henry0513
New Member
4 years ago

The link to the solution no longer work, is there another work around for the solution?

yossifisch's avatar
yossifisch
Icon for Advocate I rankAdvocate I
4 years ago

That was a link to an idea, not sure what happened with that idea but Hugo's idea is still up and accepting votes here.

 

I find SharePoint.Contents to be an efficient solution.

  • Start a blank query (Get data > Blank query)
  • Copy and paste this code in the formula bar:

 

= SharePoint.Contents("https://domaincom-my.sharepoint.com/personal/email_domain_com/", [ApiVersion = 15]){[Name="Documents"]}[Content]

 

  • Replace [domaincom] with your SharePoint domain, and [email_domain_com] with your login email. For exmaple, if your domain is mycompany.org and your email joe at mycompany.org,  you'd use:

 

= SharePoint.Contents("https://mycompanyorg-my.sharepoint.com/personal/joe_mycompany_org/", [ApiVersion = 15]){[Name="Documents"]}[Content]

 

  •  This should bring up the credentials window and, once logged in, should persent a table of all the files and folders in your OneDrive root folder
  • You can navigate to the desired folder by clicking on the 'Table' link in the 'Content' column next to the desired folder name