Microsoft released a new task called “OData Source” which helps us to connect to online SharePoint and extract the lists.
Follow the below steps to configure and extract the data.
This article explains to you that how we can use SharePoint list as a source for Power BI and also extending the Power BI report to embed on SharePoint.
I am following the same strategy in all my blogs. Reading a big paragraph is tough than a step by step points as it is easy to follow and remember.
Follow the below steps,
Step 1: Create a SharePoint list as per your business needs. It can be simple or complex with calculated columns. In my case, I created a simple SharePoint list with some sample content as like below.
Step 2: Get the SharePoint URL where the list is created.
Step 3: Open Power BI Desktop and click Get Data.
Step 4: Choose SharePoint Online List, if you use O365. Click Connect
Step 5: Pass the O365 SharePoint URL and credentials.
Step 6: Choose the list and click Load.
Step 7: It will load all the columns from the SharePoint list. Choose the visualization and map with the respective fields.
Step 8: Save and publish the report to Power BI online services
Step 9: Login to app.powerbi.com with your credentials.
Step 10: Open your report from your workspace where you published.
Embed the Report in SharePoint
So far, we created a report using SharePoint list. Now we are going to embed the report in SharePoint.
Follow the below steps.
Step 1: Open the report in app.powerbi.com
Step 2: If we have O365 E series license then we can use “Embed in SharePoint Online (preview)” option otherwise choose the below option.
Step 3: It will ask you to publish.
Step 4: Finally, it will generate URL and iframe code to place on any web page of SharePoint.
Step 5: Go to SharePoint page and edit where you want to embed this report.
Step 6: Click Insert and choose the Embed Code
Step 7: Copy and paste the iframe
Step 8: Save the page.
Share your comments below.