Dynamics 365 Portal: What’s Awaiting in the Latest April Release?

As promised, Microsoft has been providing regular updates to Dynamics 365. If you have already been using great new features from October 2018 release, and are looking forward to new features in next release – April 19, we have a piece of great news for you. Microsoft has published and shared their April 19 Release …

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 …

How to Use Aggregate Functions with Multiple Tables in Power BI

Objective If you’ve been following my blogs, you’d be half expecting this ‘complexity’ that I mentioned in my last blog. However, for those you haven’t been following the series, you can still start afresh from this. In this case study, I’ve a Customers table, named Table 1 with one column with unique values – say …

How to use Power BI in the context of SharePoint?

Who should use PowerBI? Anyone who knows the pain of presenting data in the form of charts/graphs, with added complexity of dynamic filters. However, if you are a consultant, trust your skills to link even oranges to iPhones…if you ask me how, I’d say iPhones are from Apple, apples and oranges are fruits…any further explanation …