Excel for BI Reporting and Publishing Through SharePoint – Part 3

In the previous two articles of this article series, I have explained about how to create an Excel-based BI report using the SharePoint List data OData Service in Part 1 and then discussed how to establish the connection between lists using the Power Pivot in Part 2. In this last article of this article series, …

Excel for BI Reporting and Publishing Through SharePoint – Part 2

In my previous article I have provided the instructions about how SharePoint list(s) can be imported into Excel using OData Feed option, and how it helps in real-time consumption of the data when the report is uploaded to SharePoint. This is the second part of this article series. In this part I will provide the …

Excel for BI Reporting and Publishing Through SharePoint – Part 1

In a typical SharePoint scenario, we build many small scalable custom applications where the SharePoint list(s) hold the data. One of the major challenge faced by SharePoint developers is BI Reporting of the data produced by such applications. Power BI is certainly a go-to tool for such a scenario and is the tool recommended by …