Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
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.
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
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?