Forum Discussion

atem111's avatar
atem111
New Member
7 years ago
Solved

i can't link Power BI with sharepoint librairy

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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