Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
pthapa
Post Patron
Post Patron

Is there a way for instant refresh of PBI report?

Hello all,

I have a qeustion came up from the client. Is there a way in Power BI service that when a user gets to the workspace (report), the data is refreshed instantly ?
Normally in SSRS reports, when user opens the report; the report will refresh at the same time however not sure if we can have similar experience in Power BI service.

Besides the user going into the semantic model and clicking on the 'Refresh now' button; is there an alternate/better way to do it. Clicking on the refresh now button is not always user friendly for all users.

Any guideance or tips would be helpful.

Thanks,

pthapa

1 ACCEPTED SOLUTION
v-jtian-msft
Community Support
Community Support

Hello,GilbertQ ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hi,@pthapa .I am glad to help you.

I am glad to help you.
According to your description, you want to achieve near real-time refresh of reports on Power BI Service.
I think Power BI RestAPI as well as Power Automate are good options.
You can try to use both together to create an automated process that triggers dataset refreshes at regular intervals to ensure that report data is updated in a timely manner. Implement an automated refresh process,, without the need for human manual clicks.

Even though I'm not very good with APIs, I found the following relevant information, which I hope you find helpful.
URL:
Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn
Datasets - Update Refresh Schedule - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Refresh Power BI semantic model with Data workflows - Microsoft Fabric | Microsoft Learn
How to Refresh Power BI Dataset Using Power Automate (process.st)
 

GilbertQ suggested using Direct Lake mode can also achieve similar effects of real-time refresh. direct lake mode allows Power BI to load data directly from the data lake, greatly improving the efficiency of data loading!

You can choose the appropriate way according to your actual situation, I hope my suggestion is helpful to you.

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-jtian-msft
Community Support
Community Support

Hello,GilbertQ ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hi,@pthapa .I am glad to help you.

I am glad to help you.
According to your description, you want to achieve near real-time refresh of reports on Power BI Service.
I think Power BI RestAPI as well as Power Automate are good options.
You can try to use both together to create an automated process that triggers dataset refreshes at regular intervals to ensure that report data is updated in a timely manner. Implement an automated refresh process,, without the need for human manual clicks.

Even though I'm not very good with APIs, I found the following relevant information, which I hope you find helpful.
URL:
Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn
Datasets - Update Refresh Schedule - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Refresh Power BI semantic model with Data workflows - Microsoft Fabric | Microsoft Learn
How to Refresh Power BI Dataset Using Power Automate (process.st)
 

GilbertQ suggested using Direct Lake mode can also achieve similar effects of real-time refresh. direct lake mode allows Power BI to load data directly from the data lake, greatly improving the efficiency of data loading!

You can choose the appropriate way according to your actual situation, I hope my suggestion is helpful to you.

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @GilbertQ 
Appreciate for sharing such helpful tips, I would look forward to utilize these features and excited to learn all these  in the coming days.

Thanks again for your time.

pthapa

GilbertQ
Super User
Super User

Hi @pthapa 

 

You could use at looking direct like within Microsoft Fabric, which will allow the user to always see the latest version of the underlying data in the power BI report.

 

Learn about Direct Lake in Power BI and Microsoft Fabric - Microsoft Fabric | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.