Forum Discussion

harsh's avatar
harsh
Helper I
9 years ago
Solved

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 ....
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

harsh's avatar
harsh
Helper I
9 years ago

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.