When you choose the Web option, it asks for a URL. To connect to an excel file stored in SharePoint document library, you will need to use the Web option.
We have connectors to show list data and the contents inside a folder but not really to connect with the excel file stored in SharePoint document library. Below are the options you get when you search for SharePoint.Īs you can see, none of these connectors suits our purpose. The first and the most obvious options is obviously to use the SharePoint connector from Power BI Desktop. I open my Power BI Desktop and explore the options we have. And I want to connect to this excel file from Power BI Desktop. I have the Device-Order-Data.xlsx file stored inside ‘Shared Documents’ SharePoint document library. Yes it’s easy but it’s not straightforward.
Connecting to an excel file is not something we usually consider as a challenge.
If you look this requirement, it seems really simple. In today’s blog I will show you on how you can connect to an excel file stored in SharePoint document library from Power BI Desktop.
0 kommentar(er)
