Auto Refresh Powerbi data in Powerpoint

[Atinder]

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? 

[mohammadyousaf]

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]

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]

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]

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.

[jixiaowei1224]

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]

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.

[mshenhav]

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

[Samuel_Tavern]

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

[mshenhav]

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

[amgarav]

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:

[mshenhav]

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

[Samuel_Tavern]

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

[kylesmyle]

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]

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

[Atinder]

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. 

[Daryl-Lynch-Bzy]

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.

[icretu]

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

[mshenhav]

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

[mohammadyousaf]

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, 

[icretu]

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.