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
hugoventurini's avatar
hugoventurini
Icon for Advocate IV rankAdvocate IV
8 years ago

Thanks very much for your attention. I already use this solution described, but it is not ideal because it does not allow another user to update and republish the report. Is there any prospect of having this connection in the future?

  • YatinP's avatar
    YatinP
    Frequent Visitor
    4 years ago

    This does not work for a Folder. You can only connect to root. Any options?

  • 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