Power BI Realtime Reporting on SharePoint List Data

This video will walk through the process of how to do Power BI real-time reporting using SharePoint Lists data. Quite often we get requirements from businesses to create a real-time Power BI report based on SharePoint list data. but, when we connect to SharePoint list data from Power BI, we don’t have the option of the direct query. Instead, the only available option is to import query mode. This method only allows the data refreshes up to 8 times per day with a Power BI Pro license and up to 48times with Power BI Premium.
In this demo, I will create a streaming dataset and will add new content using the Power Automate flow.

★ TABLE OF CONTENTS ★
• 00:00 Intro
• 02:07 Create Streaming Dataset using Power BI Portal
• 04:18 Create Sample Report in Power BI using Streaming Dataset
• 06:16 Create Power AUtomate Flow to Update Power BI Dataset
• 10:48 Outro & Subscribe

🔴 *** BE OUR FRIEND ***

🔎 HASHTAGS 🔎
#PowerBI
#PowerAutomate
#SharePoint

[baci]

Or just create an "import query mode" report and create a flow with "When an item is created or modified" trigger and "Refresh dataset" action.
Includes every type of changes and it is working like a charm.

[anastasianikolovski]

Great tutorial video. Was able to finally pull my data from the SP to a PBI report directly - which is near-real time :) Just amazing. One aspect didn't work in my case. It didn't pull the initial data from the SP. Although it is fine in my case, as the data I have is for only for training purposes, this might present an issue for anyone out there with the existing data records they want to preserve and pull to the streaming dataset. Anyway, thank you very much.

[AmiraJoyBona]

Hello! This is very helpful 🙏🏻 Does this functionality also works for data within SP library or only for SP list?

[charlesalves]

Hi! Thanks! And When drop, or edit data on the list?

[gipbwok]

It worked like a charm for me. Thanks KeaPoint.

[adriansilwimba]

Great Tutorial. I am an intern working for a Renewable Energy Company and I have been tasked to create a PnL Dashboard that can automatically be updated whenever the files are updated with new rows. We do use share point at my organization but I am not quite sure on how I create relational Database to automatically update in power BI.

[arsalanamin]

Hi Rashid, It is humble request to would you please guide or make video to show records more than 2 Lists to Power BI Report. Much appreciated your kind help and support.

[sheebharani]

Hi Thank you for the video. Have you uploaded a video on realtime update/delete data in sharepoint list with power automate similar to this one.

[pauloswardblad]

Hi Rashed
Thank you very much for your demo, it was realy easy to follow along and it works . Big thanks:).
I have two issues
1. when i delete a row on the sharepoint list, it still retriving the same data
2. when i update a status (i have status field ongoing, paused, finished) on the sharepoint list, it does not update.
I know you mention early in the video about the update.
Are you gonna make a video about update, or do you know where i can find information to add this to the power automate?

[komanglayang]

Hello, thank you very much for the helpful video. I was wondering if you have covered another topic similar to this one but with row update and deletion using Power Automate?

[dejantrajkovic]

Hello! This is very helpful. The problem that we have is when you are editing data that is already in the streaming data set he will keep the original and add new edited rows, so you will have 2 rows for the same ID. Is there a way that you can remove all rows from a streaming data set and then push new data using Power Automated?

[simonbuchner]

Thanks a lot! You really helped me out😀

[mvchowdary]

Nice video Sir, Can you please tell how to automate the downloading of Reports from Power bi service instead of downloading manually and store in Share point.

[mohammadazrinjamsari]

Hi, just want to check if you have uploaded the video on how to set a flow in power automate when we update/delete data in sharepoint? Thanks!

[soumyadeepmondal]

Hi!
Great video...
Just wanted to know can this method be implemented for getting real-time data from MSP Online as well?
Thanks!

[nooreldali]

Great video!!
How can we transform the data? viewing the data in table view is not possible in Power BI, I have a percentage column that I would like to present in percentage but so far it can only be a decimal number (e.g. 0.5 instead of 50%) also I can not remove the thousands delimiter from the column "Year" which I defined it to be a number field in the streaming dataset.
Can you help please?

[paragbhokre]

This helped, however need more advise on how to remove a specific item from the streaming dataset, is it possible?

[gashuanley]

Great video! Can we create a report using Power BI Service without Power BI Desktop?

[MijalisMendiz]

Hello!
Thanks for the video! I'm wondering, is it possible to do it the other way? I mean, create a list in SharePoint from PowerBI data and update the list when the data changes in PowerBI
Cheers!

[simnaumesh]

Hi, Is there a way where we can create a list in SharePoint with data that has been created powerbi table (dataset) with all calculated columns included using flow? More of the reverse process that has been explained here.