Create Live or near real time power bi report/dashboard based on sharepoint list

[aisyaharimurti]

Hi!

So i have a sharepoint list, called List A. I want to create a power bi report based on this list and embed it on my sharepoint page. but, i want it to be live/nearly realtime data showed up. the list A is updated almost everyday such as update a certain information on a column and add new item. is it possible to do it by system?

now, i only make a power bi report but not real time updated. i need to updated it regularly

[Anonymous · Accepted solution]

Hi @aisyaharimurti ,

Since sharepoint list only supports imported mode, you need to configure a refresh of the data model to get real-time data. The following two methods are for your reference.

• Configure the incremental refresh and use parameters filter Modified column to get the latest modified data.Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...
• Use the Power Automate to refresh the data source. Trigger is "When an Item is created or modified". Each time a user modifies or creates a record, the data model is refreshed.

The limitation you should be aware of is that the user must manually refresh the report Page or SharePoint Page to see the latest data. For import mode reports and SharePoint Page, there is currently no way to implement an automatic Page refresh.

Best regards,

Mengmeng Li

[SaiTejaTalasila]

Hi @aisyaharimurti ,

If update data 4-5 times in a day then you check it.

For Excel folder it works  -You can build a power automate flow whenever it sees any updates in your excel file(When a folder/file is modified) it will trigger and in the next step use refresh a dataset trigger.

I hope it will be helpful.

Thanks,

Sai Teja 

[MFelix]

Hi @aisyaharimurti ,

Check if this link can help you.

https://www.youtube.com/watch?v=jmJJHFGwWFc

[christinepayton]

Streaming datasets were deprecated recently: https://powerbi.microsoft.com/en-us/blog/announcing-the-retirement-of-real-time-streaming-in-power-b...

There is not a way that I'm aware of to do truly real-time reporting with SharePoint data, you would need to be using a source like Dataverse or SQL with direct query, or settle for the number of refreshes per day that are provided by your license tier on import mode. @aisyaharimurti