Forum Discussion
Helper IConnecting PowerBI to a SharePoint Folder
Helper ISorry should ahve said "merging multiple files within a folder"
So just struggling to connect to our data folder called:
https://mycompany.sharepoint.com/sites/GlobalDataRepository/DataStore
Helper II wanted to clear up my terminology here and bit clearer in my problem
I now have visibility in PBI desktop to our base SharePoint website listed below.
I do this by navigating to -> get data ->SharePoint Folder and connecting to the following link.
https://mycompany.sharepoint.com/sites/GlobalDataRepository
However, data appears in here as source data rather than allowing me to navigate further.
This maybe because I picked “SharePoint Folder” option above
I need to go to a library called DataStore as per the link below
https://mycompany.sharepoint.com/sites/GlobalDataRepository/DataStore
In PBI web services, it is possible to navigate there by going to Create -> Data Sets -> Create New Content -> Files -> SharePoint Team sites -> entering the first link above.
I’ve tried getting data as a Text/CSV in PBI desktop by inserting the web address in the windows folder address bar but the error message returned says “Windows cannot find … Check Spelling”
I’m really doubt this cannot be this complicated but any help on this please …..
- Minseven
I don't get your problem. You need to connect on https://mycompany.sharepoint.com/sites/GlobalDataRepository
from there, you will have access to all the files listed in your sharepoint (included in DataStore)
click Edit as per screenshot and select and combine your data:
If you still have an access problem, please reset your credential: File > options & Settings > Data source settings
Clear then permissions and reconnect using Microsoft Account by logging in by using the same level to apply the setting (https://mycompany.sharepoint.com/sites/GlobalDataRepository)
- Pateen
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
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:
