Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
i want to load excel file from sharepoint path.
how to connect and load those filess. is there any way?
Solved! Go to Solution.
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 Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@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/
Hi. You can try something like this
Regards,
Happy to help!