load file from sharepoint

[Anonymous]

Hi all 

i want to load excel file from sharepoint path.

how to connect and load those filess.  is there any way?

[dax · Accepted 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.

[amitchandak]

@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/

[ibarrau]

Hi. You can try something like this 

https://www.c-sharpcorner.com/blogs/connect-to-excel-file-stored-sharepoint-online-from-power-bi-des...

Regards,