How can I get data from a sharepoint csv file?

[Anonymous]

I have a csv file on sharepoint that I am trying to retrieve. Currently, what i did was get data > csv and navigated to the csv file on my onedrive. This works, however, when I later upload this to power bi service to a workspace owned by someone else, they are unable to schedule refresh as they can't find the csv file (since I specified a local path to the csv on my onedrive). I thought a solution would be to give a sharepoint link using get data > webbut it gives the error "object reference not set to instant". How can i fix this or is there a better way to achieve this?

[v-zhangti]

Hi, @Anonymous 

Please refer to the following link, hope it can help you.

https://docs.microsoft.com/power-bi/connect-data/service-comma-separated-value-files 

https://docs.microsoft.com/power-bi/connect-data/refresh-csv-file-onedrive 

https://community.powerbi.com/t5/Service/CSV-file-from-SharePoint-refresh-credentials-issue/m-p/1576772 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexanderPrime]

You need to go via the "Sharepoint Folder" connector and navigate to the file in Transform Data. 

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

While this guide mentions excel files. CSV applies to this as well. 

[rbarral]

Hello, sorry i tried but we cannot see the CVS file only xls,, any other help 

[rbarral]

sorry yes it work I had to load more data 

[Anonymous]

@AlexanderPrime 

Tried it but doesn't seem to work. I used = SharePoint.Files("https://companyone-my.sharepoint.com/personal/User_company_com/", [ApiVersion = ... in get data but it automatically navigates to the folder https://companyone-my.sharepoint.com/personal/User_company_com/Documents/Documents/Reblend/ 

I have another folder called Reblend_v2 inside Documents but this is not displayed for some reason. Any idea why?