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
Building a SharePoint Farm involves several steps to make sure the site will be utilized by the business users. Governance takes a big part on the design of the Sites(s) Depending of the size of your farm is conceivable that you will need more than one site colleciton to allocate your business data and to keep security permissions isolated among all the business units. here is where creating programatically all your site collections becomes handy, specially when you don’t have to
SharePoint has been widely being used in organizations for enterprise content management but with growing user base sometimes leads to common bad practices that causes a lot of frustration among SharePoint users. One of the best practices of SharePoint is to setup navigation correctly. SharePoint navigation is the first things users rely on besides searching to navigate to other site. If navigation is not correctly setup you will see in many places not only it decreases user’s adoption of SharePoint