This website uses cookies to ensure you get the best experience on our website.
Accept

SharePoint Workflows: Streamlining Business Processes with Automation

Did you know that SharePoint workflows can save you and your organization a significant amount of time and effort? According...
Read More
SharePoint Workflows: Streamlining Business Processes with Automation

Seamless Project and task management with SharePoint project management

For any organization, big or small, effective project management is essential to its success. Multiple stakeholders, a wide range of...
Read More
Seamless Project and task management with SharePoint project management

Best Knowledge Management Software in 2023

If you're looking for the best knowledge management software for your organization, you're in the right place. In this guide,...
Read More
Best Knowledge Management Software in 2023

The Future of Forms: Upgrade from InfoPath to PowerApps

Are you tired of using outdated technology for your business processes? With the end of support for InfoPath, it's time...
Read More
The Future of Forms: Upgrade from InfoPath to PowerApps

Maximizing Your Productivity with These 11 SharePoint Features

Looking for a game-changing tool to help streamline your workflow? Look no further than SharePoint, the all-in-one solution that makes...
Read More
Maximizing Your Productivity with These 11 SharePoint Features
Power BI SharePoint Integration

Power BI SharePoint Integrations in Quick Steps

Modern-day businesses leveraging SharePoint online, keep collecting huge amounts of data on their lists. But this data does not make sense until they can analyze this data using Power BI or any other business intelligence tools. And to analyze this data- it becomes crucial that we integrate your SharePoint online with Power BI.  

With Power BI dashboards and reports, your teams are more confident in analyzing data in the right manner at right time and can make informed decisions about their tasks, goals, or businesses. Let’s understand how these two platforms can be integrated with a step-by-step guide here 

What is SharePoint  

SharePoint is a platform developed by Microsoft to create internal websites or team sites where coworkers can collaborate and store documents etc. We can also create site collections with different websites and subsites and allow our team members to work on a site and easily collaborate. Collaboration is one of the most powerful features of SharePoint. 

What is Power BI 

Power BI is a Data Visualization and Business Intelligence tool/service provided by Microsoft. It is a collection of apps,data connectors, and software services to get the data from different data sources, transform the data, and produce useful reports.  

To move data from SharePoint into Power BI we need the following prerequisites: 

  1. SharePoint License  
  1. SharePoint List or Library 
  1. Power BI Desktop app 

 Power BI SharePoint Integration Method: 

How to get data from the SharePoint library or list into Power BI and embed the data in Power BI Report: 

In SharePoint, we have document libraries with folders and documents you can transfer the data into Power BI.  

  1. The first step includes downloading the Power BI Desktop Application. Once installed, go to the Home Tab to access the “Get Data” tab, which has multiple options in the dropdown menu.

 

        Power BI Desktop

  1. Click on the “More” button from the dropdown menu. The Get Data dialog box then appears in the search bar. Search for SharePoint and three options will appear: 

Get Data

  1. ‘SharePoint folder’ 
  1. ‘SharePoint Online List’ 
  1. ‘SharePoint List’  

You can choose one option for accessing the data, which can be listed as ‘SharePoint List” 

  1. Then click on “Connect” at the right bottom of the dialog box.
  1. Another dialog box appears with the click on “connect”. In the dialog box, type in the SharePoint site URL, to fetch the list/library and click ‘Ok’ to connect.

      SharePoint Folder

  1. Enter your SharePoint site credentials to allow access to the SharePoint site and then click ‘connect’.

 

  1. In the left-side Navigator menu, select the checkbox next to the SharePoint list you want to connect.

    Navigator

  1. Click on ‘Load’ to fetch the data into the Power BI Desktop.Once your SharePoint data is finished loading, you can use it to build a report on Power BI. Some of the data types you can include for content are:
  • Date Accessed 
  • Date Created 
  • Date Modified 
  • File Extension 
  • Folder Path 
  • Name 

How to Create a report on a SharePoint List in Power BI Desktop: 

  1. On the left side of the home screen for the Power BI desktop app, select the ‘Data’ icon to discover how to fetch the data from the SharePoint list.   

      Select Data Icon

    2. Create the reports on the left side, select the ‘Report’ icon. 

Select Report Icon

    3. Select columns you want to visualize by selecting the checkbox next to them in the ‘Fields pane’ on the right. 

    field pans

    4. With the help of the Visualization Pane, you can change how the data is displayed on the reports.  

    Visualization

    5. You can create multiple visualizations in the same report by unchecking the existing visual, and then selecting checkboxes for other columns in the ‘Fields’ pane. 

    6. Select ‘Save’ to save your report. 

There are one or more ways to create Power BI Reports- 

  1. In a SharePoint list or library, use the following path:  Integrate > Power BI > Visualize. You can then access the listorvisualize the library. A new browser tab opens with an automatically generated report.  

Integrate Power BI

     2. You can easily change the data in the report. In the ‘Summarize pane’, add or remove fields from the report.               Select and unselect fields to update what you want to measure and analyze. Power BI automatically adds or removes charts to show the new combinations. 

Change Data in report

    3.To share the insights you find with others on your team, you can publish the report back to the list or library using the Publish to the list or the library button in the app bar. 

Publish to the list

 4. Name your report and confirm you’re ready to publish it back to the list or library. Once published, everyone who has access to the list or library can open the report, and see the data in the report. 

Let’s also see how we can display Power BI Report on SharePoint Page.  

After you publish a Power BI Report, a link is generated and anyone with the link can open it on a new tab and access the report. But there are multiple options where you can embed the report directly into the SharePoint page. To embed a report on a SharePoint page, you must use a special web part for Power BI.  

  1. To add a Power BI report, choose the Power BI web part.

SharePoint 2019 For Dummies 

  1. Once you add the web part to a page, you need to configure it. The configuration is simple. You provide the link to the Power BI report, and SharePoint takes care of rendering it for you inside the SharePoint page.

Configuration in SharePoint 2019

 

Power BI Report

Final Thoughts.  

This is a simple, fast way to integrate SharePoint with Power BI. We can visualize large amounts of data in the form of easy-to-understand reports. Also, you don’t need to jump between platforms because you can embed Power BI report into SharePoint, so users can easily see the data on their existing SharePoint site.  

If you face any difficulties or need help with your SharePoint integration with the Power BI tool, at Beyond Intranet, we have a full-fledged team of Microsoft-certified Power BI experts who can help you with your integration needs.