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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Atinder
Helper III
Helper III

Auto Refresh Powerbi data in Powerpoint

Hello, 

 

I Embed live data from powerbi to Powerpoint powerbi Add-ins.  How can I set this on auto referesh? 

I created this data so our team can see these reports on the TV throughout the day . I want this to be refresh as soon as report is refereshed. how can I do this? 

Atinder_0-1660850574146.png

27 REPLIES 27
mohammadyousaf
Resolver I
Resolver I

same is happening with me, I have to reimbed all graphs into powerpoint, some are getting refreshed and some not at all. I need to do this every month for a monthly report. 

kylesmyle
Frequent Visitor

Depending on what your setup is like, this can be done using two programs. A macro app and the Task Scheduler app in Windows.

PowerBi data will refresh when you reopen power point, so you can make a macro that opens PP and then presses F5 to run slideshow. You then use Task Scheduler to open your macro file exe on a schedule. You would also have to make a macro that closes PP too (Alt-F4).  A variation of these could help you

pay_2019
Advocate I
Advocate I

We used a macro program called Tiny Task, but Power Automate would also give you the ability to set a restart process in place.

 

Currently we have moved away from using the Powerpoint option for a screen show, and now we are using Vue Pilot instead. If they can fix the issue on Power BI we may switch back to this option.

icretu
Regular Visitor

Hi!

This thread is dead? 

Has anyone figured out if the powerpoint slides can be updated every few hours or when the page reloads? I need to run this presentation in loop forever with 6-10 slides with a power BI report on each slide.

In the add-on options in the lower right corner, there is a slideshow setting, where you can set the refresh time interval

pay_2019
Advocate I
Advocate I

I also want to be able to display a rolling Powerpoint presentation on TV screens which will loop in the office and show the KPI data for the business, unfortunately once you set it rolling on a continous loop it no longer updates the data which is being refreshed on Power BI, so not much use for presenting latest data on screens.

 

Anyone any other ideas on what can be used for presenting multiple reports on a screen? I have tried using Dashboard Rotator without success as well.

Hey @pay_2019 , @Atinder , @mohammadyousaf , @kylesmyle , @pberk 

 

Power BI add-in now has auto refresh configuration that you can set for continuous slideshow scenario. 

You can read more about it here: https://powerbi.microsoft.com/en-us/blog/supporting-continuous-slide-shows-in-power-bi-storytelling-... and here: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-what... 

 

Can this help with your scanario?

 

Thanks, Maya

 

Thanks a lot for the link. However we tried it with some colleagues, at the moment when the PowerPoint is in slide show and the data is refreshed a message is dispalyed in the bottom left corner of the screen, saying that fresh data is ready and can be refreshed by clicking on the button. How to have this refresh done without asking for the user's input?

Thanks a lot for your help,

Samuel

Hey @Samuel_Tavern ,

 

You can configure the add-in to automatically refresh while in slide show. please read this blg post with the details: https://powerbi.microsoft.com/en-us/blog/supporting-continuous-slide-shows-in-power-bi-storytelling-... 

Once you set the refresh frequncy, it will automatically pull data from Power BI while running in slideshow, without any human interaction.

 

Thanks, Maya

Hi, So I'm facing a issue regarding this topic. I have the PPT embed with the PBI report and it refresh only when I open the file and go through each page. But I'm trying to do an auto refresh without open the file and then sending PDF file from it. How can I make the PPT refresh for this purpose?

I'm using the following flow, but as I said the ppt still without refreshing the Power BI visuals:

amgarav_0-1722601353493.png

 

Hey @amgarav ,

 

For you scenario I would suggest to use a Power BI API that the lets you export Power BI Report as static PDF: https://powerbi.microsoft.com/sv-se/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest... and not the Power BI add-in, which was created for more dynamic presentation.

 

Thanks, Maya

Hi Maya,

Thanks a lot for your answer, indeed after further tests it does work smoothly!!

There is still a big hurdle remaining for us to adopt this solution to display data, it is that the PowerPoint slideshow pauses if another software is used on the computer at the same time. I guess this is more of a PowerPoint issue than a PowerBI one anyway.

 

 

Best regards,

Samuel

Will it update while the slideshow is in full screen play-mode? If so, then it would be a great new feature!

Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi @Atinder -  What make you think that the data is not being refreshed?   Are you using the new Power BI PowerPoint feature (Add a live Power BI report page to PowerPoint - Power BI | Microsoft Docs).  Since you are embedding an Live tile in PowerPoint, it will be refreshed when the PowerPoint is opened with the new data and with any changes made to the report page.    If the page in PowerPoint is not refreshing there is button in PowerPoint to refresh the report.  View and present live Power BI report pages in PowerPoint - Power BI | Microsoft Docs

 
 

 

 



It does that but everytime I have opena nd close. I have 22 slides in the powerpoint but I can't do slide show it just stuck at slide one and white out. 

Hi @Atinder - if you have a Power BI Report which contains 22 pages and you want to include each page in the PowerPoint presentation, you need to embed the link for each page separately.   Embed Power BI in PowerPoint interactive - YouTube

 

Note Microsoft did not included a page navigator in their new add-in (suggest this at PowerBI Ideas).  I suspect they did this because they did not antipate you using PowerPoint to present too many pages  (death by PowerPoint? or just share the Power BI report or share as PDF). 

 

If you prefer to insert one slide and then navigate within this single slide, you can consider adding a Page Navigator (Create page and bookmark navigators - Power BI | Microsoft Docs) to each page in the Power BI report, or a next and back buttons to each.

Now it is possible to autorefresh the data.  It is still crashing some time but it is an improvement.

icretu_0-1720168700229.png

 

Hey @icretu ,

 

We made some improvements in PowerPoint to handle crashes. Can you please verify that you are running the most recent Office version?

If it keeps crashing, can you please contact us at mpbisup@microsoft.com for additional investigation?

 

Thanks, Maya

Hi Maya, 

PowerPoint is not crashing anymore and works fine. However, another issue still there when I use individual graphs then some getting refreshed but others not. 

Just to let you know that I have 17 pages PowerPoint Report which has selected graphs from the same report's different pages published in service. Some graphs get refreshed to the latest data but some remains on the old data even after manual refresh. 

Regards, 

I need to run this presentation in loop forever with 6-10 slides with a power BI report on each slide. Not to restart the presentation. Autorefresh will be good. Manual refresh... doesn't realy help.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors