Create A Power BI File Template For Different SharePoint Site Every Time

In this article, we will talk about how we can create the Power BI report using the SharePoint data sources and generate the template of the created report where the SharePoint Site URL is configurable. Once we create the template of Power BI Desktop file, we can export the file as a template. Then the end users can generate the report based on any configurable SharePoint site with a different set of data.

We have the following two site collections with the same structure of the List data.

• I have a list named “R1” in my first site collection which is “HR”.
  
  
  
  
• I have a list named “R1” in my second site collection which is “subHR”.
  
  

Assume that “R1” list is available in other 50 sites or site collections with the same list schema. The data would be different on every site.

The client is looking to generate a different Power BI report for every site collection from one generalized template where all the charts are already created.

User will open the template file and add their credentials and generate the report automatically. They will save the report in their local machine and publish the report to their own “My Workspace”.

So, now let’s get started with the step by step procedure!

Load the data to Power BI Desktop from SharePoint Online.

1. Click on "Get Data" from Home.
   
   
   
   
2. From Online Services, select “SharePoint Online list”.
   
   
   
   
3. Enter URL
   
   
   
   
4. From Authentication, select Microsoft Account. Click on the Load button.
   
   

From Home, click on Edit Queries,