i can't link Power BI with sharepoint librairy

[atem111]

Hi All

I am trying to link Power BI with sharepoing library in fact once i add the url , Power BI open a new blank page with the butoon Load & Edit .

If i try to do the same move with sharepoint list , it works correctly 

Do you have any idea what is the issue for this ?  i have attached an excel file in Sharepoint library and i need to link with power Bi for live data 

Thank u

[v-yuezhe-msft · Accepted solution]

@atem111,

Do you want to connect to the SharePoint Online excel? if so, you can use web connector in Power BI Desktop following the guide in this similar thread.

Or you can use SharePoint Folder connector as described in this blog: https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/.

However, if you want to connect to on-premises sharepoint excel, you can also use SharePoint Folder connector, just make sure that you use Windows authentication type.

Regards,
Lydia

[atem111]

Thank you ..Appreciated