How to Integrate 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 SharePoint to leverage all its benefits. So get ready and stay tuned for such exiting articles in the 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.
Integrate Power BI 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 a 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 the online tools 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 the 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 a local file to choose an 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 a report.
Now based on the requirement you need to choose a desired visual design for the 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 requirements. In which I can see all the blacklisted hospitals based on the City, Pin code and State thus selected from the 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 the 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 the “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 a different hierarchy.
Now if you remember we have opted data based on a few table selections City/Pincode/State.
You can now switch hierarchy based on this selection and by each switch, you can see different data representations. This is the power of this report. Below are examples of different options.
This report can be shared on LinkedIn, Twitter and so on. These options you can find at the bottom of this report.
You may like following Power BI tutorials:
- How to combine multiple files from SharePoint folder in Power BI
- Power BI: How to Connect Most Recent File from a Folder
- Publish to Web Power BI Error: Contact Your Admin to Enable Embed Code Creation
- Create Power BI Dashboard step by step tutorial
- Integrate Power BI Reports in SharePoint Online
- Display Power BI Report in SharePoint Online (using iFrame and Provider Hosted Apps)
- Data Refreshing issue Access Denied to Analysis Services Database Contact Administrator in PowerPivot in SharePoint BI services
This tutorial, we learned how to integrate power bi reports in sharepoint online.
Download SharePoint Online Tutorial PDF FREE!
Get update on Webinars, video tutorials, training courses etc.