Forum Discussion
Auto Refresh Powerbi data in Powerpoint
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
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?
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 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.
Hi Anonymous I embed link for each page but as soon as I hit slide after 1 slide Powerpoint crash or whiteout.
