Integration of Power BI with SharePoint Online
Check out Best Alternative to InfoPath -> Try Now
Hi folks, from today I am starting a new blog series on Power BI. I will try to capture all possible information about Power BI in terms of a tool as well as how to use this power full tool on to SharePoint to leverage all its benefits. So get ready and stay tuned for such exiting articles in future.
What is Power BI?
Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, and then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. Moreover, scale across the enterprise, with governance and security built-in. For any business that is using Office 365 and you have access to SharePoint online you can embed the Power BI report directly into a SharePoint Online modern web page. As well as add into embed code normal page.
PowerBI integration with SharePoint Lists
Analyze and visualize your SharePoint data. Centralize your data, simplify it with queries you create, and share it in visual reports.
Bring your data together
Import large volumes of data from multiple sources into Power BI Desktop. Edit the data before pulling it in or transform and shape the data after it is imported.
Explore your data in fresh ways:
Visually explore your data with a variety of customizable reports. Create visualizations by dragging and dropping the fields you want to view. Choose from a variety of charts and graphs to tell your data’s story.
Let your data work for you:
Once you have created your report, you can share the file like any other file. You can also publish it to the Power BI service where colleagues can interact with it.Connect to what matters to you. Excel spreadsheets, on-premises data sources, big data, streaming data, and cloud services: it does not matter what type of data you want or where it lives, connect to hundreds of data sources with Power BI. Below are few sources listed.
Prerequisite – If you want to publish reports / dashboards on SharePoint directly:
– SharePoint Server and Site
– Power BI Desktop Version Software available @ https://powerbi.microsoft.com/en-us/desktop/
– Dashboard Prepared and published on https://app.powerbi.com/ (need a Pro license to leverage all the benefits.)
Here today we will see how to use online tool from scratch.
Step-1- Sign in to your account with valid credentials on https://app.powerbi.com/
Once you login you will see below screen, where at bottom you have to click Get Data to choose a data source from which you will create reports / dashboards as shown below.
Now we will choose local file to choose a excel file to understand a process, here you have so many options to choose data source from which we will explore one by one.
Once file is selected you can either import or upload data, while import data you might get below error as data is not formatted in a tabular format. To avoid such errors select data and press Ctrl +T .
Note- Data coming from any data source is internally converted into tables .
Once format conversion you can see a Dataset created with the same name , choose this to create report.
Now based on the requirement you need to choose a desired visual design for representation of your data also you can choose different filter options based on conditions .
Here I have selected a pie chart design which suits my business requirement. In which I can see all the blacklisted hospitals based on the City, Pin code and State thus selected from tables section (right hand side)
Once we are done with our reports we need to now save by giving some meaning full name to identify under our workspace.
Now I want to publish my report directly to my SharePoint site for that need to publish to web as shown below. From the dashboard expand Workspaces -> Publish to web.
Then in the “Embed in a public website”, click on “Create embed code” like below:
Then click on “Publish” button like below:
This will show the successful message and you can copy the iframe code like below:
Once published we need to copy this embed code (iFrame one) and paste in our web part page inside script editor web part. Now publish this page. You can see your report which can be viewed into different hierarchy .
Now if you remember we have opted data based on few table selection City/Pincode/State.
You can now switch hierarchy based on this selection and by each switch you can see different data representation. This is a power of this report. Below are the examples of different options.
This report can be shared on LinkedIn , twitter and so on. These options you can find at bottom of this report.
Hope this article will be helpful.
SharePoint Online FREE Training
JOIN a FREE SharePoint Video Course (3 Part Video Series)