Forum Discussion
How can I get data from a sharepoint csv file?
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?
5 Replies
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.Tried it but doesn't seem to work. I used = SharePoint.Files("https://companyone-my.sharepoint.com/personal/User_company_com/", [ApiVersion = 15]) 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?
Hello, sorry i tried but we cannot see the CVS file only xls,, any other help
sorry yes it work I had to load more data
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
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.
