Forum Discussion

Pateen's avatar
Pateen
Helper I
7 years ago
Solved

Connecting PowerBI to a SharePoint Folder

Hi, I am trying to connect to my organisations’' SharePoint account so I can retrieve CSV files as a Power BI data source. I am using a SharePoint URL (i.e. https://mycompany.sharepoint.com/sites/G...
Need Help
Show and Tell
  • Minseven's avatar
    Minseven
    7 years ago

    If you can see it (screenshot) you can access it!

    click Edit. In new screen > filter by your file names (Thats's why naming your data is important here) > Then combine your file:

     

     

     

  • Pateen's avatar
    Pateen
    7 years ago

    Thanks you Minseven 

     

    That works perfect

Pateen's avatar
Pateen
Helper I
7 years ago

Thanks for your reply Minseven ,

 

I can see the same information you have shown me when I connect to on side.

I can view the filenames, extention, Dates, Folder names etc.

 

The problem is I want to access whats inside the files themslves (csv & txt data) and not just have information about the files. 

I've tried various other methods (OData, CVS, etc) to getting this data on our sharepoint site but again run into the same problem.

 

Like I was saying, its a very simple problem whihc I just cannot seem to solve.

Any ideas at all 

 

Pateen

 

Minseven's avatar
Minseven
Helper I
7 years ago

If you can see it (screenshot) you can access it!

click Edit. In new screen > filter by your file names (Thats's why naming your data is important here) > Then combine your file: