topic Re: Auto Refresh Powerbi data in Powerpoint in Developer

Auto Refresh Powerbi data in Powerpoint

Atinder — Thu, 18 Aug 2022 19:26:50 GMT

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?

Re: Auto Refresh Powerbi data in Powerpoint

Daryl-Lynch-Bzy — Fri, 19 Aug 2022 18:43:17 GMT

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

Re: Auto Refresh Powerbi data in Powerpoint

joekios — Tue, 23 Aug 2022 06:06:12 GMT

I didn't start this thread, but one scenario I personally would like to have some kind of auto refresh setting is if the presentation is looping on a big info screen in the office, or similar. It would be great to be able to make it update every few hours or so by itself.

Re: Auto Refresh Powerbi data in Powerpoint

Atinder — Tue, 23 Aug 2022 13:06:05 GMT

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.

Re: Auto Refresh Powerbi data in Powerpoint

Daryl-Lynch-Bzy — Tue, 23 Aug 2022 13:46:59 GMT

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.

Re: Auto Refresh Powerbi data in Powerpoint

Atinder — Tue, 23 Aug 2022 19:27:18 GMT

Hi @Daryl-Lynch-Bzy I embed link for each page but as soon as I hit slide after 1 slide Powerpoint crash or whiteout.

Re: Auto Refresh Powerbi data in Powerpoint

pay_2019 — Thu, 13 Oct 2022 08:23:37 GMT

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.

Re: Auto Refresh Powerbi data in Powerpoint

icretu — Tue, 08 Nov 2022 08:36:25 GMT

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.

Re: Auto Refresh Powerbi data in Powerpoint

pay_2019 — Wed, 23 Nov 2022 16:32:32 GMT

I am still having problems with the slideshow on loop, which does not autorefresh. But as it does refresh on opening I have decided to use a separate macro program to close the slideshow and reload the data then start the slideshow again. I think this is the only option we have now.

Just one other point, dates on the slideshow are coming out in US format as a standard, when I want it to display in UK format, any suggestions on this?

Re: Auto Refresh Powerbi data in Powerpoint

icretu — Wed, 11 Jan 2023 12:27:37 GMT

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.

Re: Auto Refresh Powerbi data in Powerpoint

pberk — Fri, 11 Aug 2023 15:39:51 GMT

Thanks for this! I also assumed a separate macro would be the only method of prompting the embedded BI report to auto refresh.

Do you mind sharing what macro program you used to accomplish this?

Re: Auto Refresh Powerbi data in Powerpoint

pay_2019 — Mon, 14 Aug 2023 10:32:21 GMT

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.

Re: Auto Refresh Powerbi data in Powerpoint

kylesmyle — Thu, 28 Sep 2023 17:41:30 GMT

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

Re: Auto Refresh Powerbi data in Powerpoint

mohammadyousaf — Thu, 05 Oct 2023 13:12:41 GMT

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.

Re: Auto Refresh Powerbi data in Powerpoint

mshenhav — Mon, 13 May 2024 14:08:01 GMT

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

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

Can this help with your scanario?

Thanks, Maya

Re: Auto Refresh Powerbi data in Powerpoint

kylesmyle — Mon, 13 May 2024 16:52:36 GMT

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

Re: Auto Refresh Powerbi data in Powerpoint

icretu — Fri, 05 Jul 2024 08:39:51 GMT

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

Re: Auto Refresh Powerbi data in Powerpoint

Samuel_Tavern — Fri, 05 Jul 2024 09:29:43 GMT

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

Re: Auto Refresh Powerbi data in Powerpoint

icretu — Fri, 05 Jul 2024 09:51:45 GMT

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

Re: Auto Refresh Powerbi data in Powerpoint

mshenhav — Fri, 05 Jul 2024 10:26:33 GMT

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