Forum Discussion

augustindelaf's avatar
augustindelaf
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Unable to access to SharePoint Folder with Files

Hi,    I am currently struggling to access to excel files in a sharepoint environment.   The context : multiple excel (.xlsx) files of the same type in a SharePoint folder, I try to access to the...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Well, you can answer that better than me I guess 😛 I do get the account option screen when I use your site, obviously I cannot go further but here you should login with your Office 365 account:

    Did you get this screen? And what account did you use? (And just to be totally sure: this is not a on premise SharePoint instance right?)

augustindelaf's avatar
augustindelaf
Icon for Impactful Individual rankImpactful Individual
6 years ago

hi JarroVGIT 

 

 

Thanks for your kind help.

>> Yes, my pbi desktop has access to the sharePoint environment (I have another table in that file that successfully gets data from a list into that same SharePoint, so i'm 100% sure it's not an issue)

 

Actually, I can access to the root through a "SharePoint.Tables" request (screenshot):

I can access to the root of the sharePoint. Where should I go now ? When I go to "Documents", I can see my files but I am unable to access to their content.

 

Then I have multiple options and I choose "Documents" because it enables me to see the names of my files.

But, there is no way to deep dive into their content ! 

There should be a column named "Content", to be expanded, no ?

 

Thx

JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago

That doesn't seem right, your M code refers to SharePoint.Tables but when I try it it refers to SharePoint.Files:

Are you using an up to date PowerBI Desktop version? And did you select SharePoint Folder (not list!)?

 

EDIT: when i try to connect to a Sharepoint Online List, i get a similar view as you. Seems you need to connect to a SharePoint folder.

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Kudo's are welcome 🙂

  • augustindelaf's avatar
    augustindelaf
    Icon for Impactful Individual rankImpactful Individual
    6 years ago

    Hi JarroVGIT 

     

    I cannot connect to a sharePoint.Files

     

    I tried SharePoint.Tables because sharePoint.Files doesn't work.

     

    I have an error when trying SharePoint.Files

     

    My version of Power BI is November 2019. 

    "Version: 2.75.5649.961 64-bit (novembre 2019)" 

    • JarroVGIT's avatar
      JarroVGIT
      Icon for Resident Rockstar rankResident Rockstar
      6 years ago

      Your site URL seems off. Please try replacing it with the URL i gave in the first reply

       

      e.g. https://totalworkplace.sharepoint.com/sites/lub-metiers/

       

      (note the / at the end!) Perhaps it is best to start a new query, and select Sharepoint Folder with the above URL. If that doesn't work, please post screenshots of what you are seeing.

       

      • augustindelaf's avatar
        augustindelaf
        Icon for Impactful Individual rankImpactful Individual
        6 years ago

        Hi,

         

        I did exactly like you said.

         

        > New Query>SharePoint Folder (a)SharePoint Folder

         

        Then there is an error (b)

        Details: "Access to the resource is forbidden."