In Part 1 of the series Integrating SharePoint Online and Power BI, we saw how we can create interactive reports in Power BI and easily embed them in SharePoint Online. In this post, we are going to continue with the Power BI report, created and published earlier to SharePoint, using the Purchases List. In this example, we will add another SharePoint list called Purchase Budgets and create a relationship between Purchases and Purchase Budgets, so we can report on budget variances.
Integrating SharePoint Online and Power BI As a SharePoint User, you probably have interacted with data stored in a SharePoint list. We use SharePoint Lists to collect and organize onboarding tasks, vacation requests, expense reports, sales numbers and so much more. In the past, we have been using views to group and filter SharePoint data. How amazing would it be, if we could visualize that vast amount of data in a more meaningful and interactive way? In this blog post, I will show