Forum Discussion
load file from sharepoint
Hi all
i want to load excel file from sharepoint path.
how to connect and load those filess. is there any way?
Hi Anonymous ,
You could try to by web or sharepoint folder to connect it.
1.sharepoint folder
You need to connect it by root site , then click connect to pass credential. It will show all files of all folder in root site, then you could filter folder name to choose file you want, and expand the [content] to get value
2. web
Choose corresponding file, then click like below to get path, then paste this in powerbi(delete ?web=1 in path) and pass credential, it should work
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- ibarrauSuper User
Hi. You can try something like this
Regards,
- amitchandakSuper User
Anonymous , refer if these can help
https://community.powerbi.com/t5/Desktop/Import-Data-from-an-Excel-sheet-in-SharePoint/td-p/47223
https://www.youtube.com/watch?v=3GIz50pftZ0
https://www.youtube.com/watch?v=gJF2e_43FRY
https://whitepages.unlimitedviz.com/2018/07/excel-files-power-bi-desktop-sharepoint/
https://docs.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files
https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/ - daxCommunity Support
Hi Anonymous ,
You could try to by web or sharepoint folder to connect it.
1.sharepoint folder
You need to connect it by root site , then click connect to pass credential. It will show all files of all folder in root site, then you could filter folder name to choose file you want, and expand the [content] to get value
2. web
Choose corresponding file, then click like below to get path, then paste this in powerbi(delete ?web=1 in path) and pass credential, it should work
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.