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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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

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

Hey @Atinder ,

 

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

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.

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?

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

icretu_0-1720173069457.png

 

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?

It is not macro based, but you should use Power BI add-in for PowerPoint. 

Once you configured your report, you can also turn on auto-refresh in slideshow. 

you can learn more about the add-in here: https://powerbi.microsoft.com/en-us/blog/storytellingga/

and read more about auto refresh in slideshow: https://powerbi.microsoft.com/en-us/blog/supporting-continuous-slide-shows-in-power-bi-storytelling-... 

 

Thanks , Maya

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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