Forum Discussion
How to load csv file from Sharepoint folder ?
Hello all,
I 'm new to Power BI, I need to upload data from csv file located in sharepoint folder.
This is the complete connection(not posting exact link) however it says invalid url(coz of .aspx inside it), please provide url root
https://microsoft.sharepoint.com/teams/CECRMSP/**************************/Forms/AllItems.aspx?id=%2Fteams%2FCECRMSP%2FShared%20with%20Microsoft%2FTraining%20Items
I tried this one "https://microsoft.sharepoint.com/teams/CECRMSP" it works however my folder and csv are located inside the sub folders how to get there ?
Please share how to do connections for sharepoint.
And my second question is if I upload new csv file in that location how it will get refreshed please guide me step by step
Hi harsh,
I 'm not looking to get the name of the document names in tables as in your case, I 'm trying to open csv file to load data into the tables
Indeed, I knew exactly what your requirement is. I posted those photos above just wanted to let you know that I can load all files(including all files within sub folders) using the root URL like yours.:smileyhappy: We can then load data from csv file into tables in Query Editor. Following is the table I got from my "2016-02-05 Feb.csv" file on SharePoint.
Here is an article about how to loading Excel/CSV Files from Sharepoint in Power BI Desktop for your reference.
Regards
11 Replies
Are you trying to use the SharePoint connector or the CSV file connector? Should use a CSV connector and easiest way to get link is to navigate to the document in question in SharePoint in a browser, right click and say "Get a link". It should end up looking something like:
https://tenant.sharepoint.com/Documents/Photos/Clippers%20Game%20081616/IMG_20160816_201217206.jpg
This is a link to a document buried 2 folders deep.
Hi Smoupre,
Thanks for your reply, its working Power BI online, however I was trying using Power Bi desktop and I selected csv connector didn't work, not sure whether its supported on not.
This is the complete link of my csv file:
https://microsoft.sharepoint.com/***************/_layouts/15/guestaccess.aspx?guestaccesstoken=Muclyy1iAqyveLeef8aahna6iEkuou43f6SmVkE8e8k%3d&docid=2_15e88281ae5004bad849a3e5bede2a91e&rev=1
It seems it reads till guestaccess.aspx rest it avoids.
The below figure shows some unwanter document showing.
Hi harsh,
I tried this one "https://microsoft.sharepoint.com/teams/CECRMSP" it works however my folder and csv are located inside the sub folders how to get there ?
Are you not able to load any files from sub folders when using the root URL mentioned above? I have tested it on my side. I can load all files(including all files within sub folders) using the root URL like yours.
In addition, following is another solution that using the Web connector mentioned here. Please go and check if it works.
- Click Get Data-> Web
- Provide the full path to your Excel file on SharePoint
- Select authentication as Organisation and enter your O365 user id/password if needed
- You should then see a dialog box where you pick the tables you want to pull in
Regards
Hi JerryLi,
I 'm not looking to get the name of the document names in tables as in your case, I 'm trying to open csv file to load data into the tables however I 'm not able to do that since its not able to link the document which I have already mentioned in my question and the other link you gave using web it does not work too, you can check the comments from other people saying "invalid link" and so on same error I 'm getting even after signing correctly to my organisational account.
Hi harsh,
I 'm not looking to get the name of the document names in tables as in your case, I 'm trying to open csv file to load data into the tables
Indeed, I knew exactly what your requirement is. I posted those photos above just wanted to let you know that I can load all files(including all files within sub folders) using the root URL like yours.:smileyhappy: We can then load data from csv file into tables in Query Editor. Following is the table I got from my "2016-02-05 Feb.csv" file on SharePoint.
Here is an article about how to loading Excel/CSV Files from Sharepoint in Power BI Desktop for your reference.
Regards
