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
pstaggers
Advocate II
Advocate II

Power BI add-in for PowerPoint is not refreshing after re-publishing the Power BI report

I have tried these various options (image below is screen shot from https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-insta...) for the URL and have not found a way for the Add-In in PowerPoint to refresh after I re-publish the Power BI report.

 

If I refresh the PBI report (let's say I change the date range to include the most recent 4 quarters after a quarter closes).  The Add-in seems "sticky" - it keeps the old date range (previous set of 4 quarters) regardless of whether I choose Share, Export, or Address Bar as the source of the URL.  I have to use the "Clear Data" option to add the same URL again, and then I get the right result.

 

This means a whole lot of manual updating every quarter when the new data is available.  The MS article seems to indicate behavior should be otherwise, but that's not what is happening in practice.

 

pstaggers_0-1663101293112.png

 

7 REPLIES 7
mshenhav
Power BI Team
Power BI Team

hey @pstaggers ,

Have you consider using a relative date filter in your report? 

 

Maya

Vogan
Regular Visitor

Facing the same issue.  Might as well copy and paste picture if we can't get a live update.  

mahesh_powerbi
Frequent Visitor

@pstaggers @v-henryk-mstf 
I am facing the exact same issue. 

I have a dashboard published to Power BI service. Using Powerpoint add-in, I am trying to use the dashboard in Powerpoint. Upon changing filters in Power BI service, I expect the powerpoint add-in should update the dashboard (either after restarting Powerpoint or after manually clicking refresh or reload in the add-in). However, it is not working.

 

Please let me know if you find a workaround.

Thanks 

I agree with your expectation for how it should work.  I have not yet found a workaround, but I'll share if I do find one.  

v-henryk-mstf
Community Support
Community Support

Hi @pstaggers ,

 

I can't reproduce your question for now. Can you provide a screenshot of the relevant operation steps and describe them so that I can answer your question as soon as possible?


Looking forward to your reply.


Best Regards,
Henry

 

I'm getting the same issue, any solutions yet? seems to defeat the object of embedding the visual???

I added a filter to my report and expected it to show up, instead I'm having to delete and re-insert 

Hi #itcheyeballs, I have not seen a full resolution, but it does seem like the feature has gained some improvement since I first posted (more robust that at first).  I now use it with more confidence but still see this particular issue.  It is almost as if the URL itself is coded to the initial set of filters (and that by re-writing over that URL with the updated one you get the intended data).  I just tried it again with my data and got the same issue, so no, not resolved.

 

Also, I have noticed that when I have several slides, if I click into the first slide it goes out to update the PBI Add-in for that slide alone.  If I had the add-in on 10 slides, I have to go and click into each to get the updates to occur.  There do not appear to be controls for when/how the PPTX file updates the PBI info (other than manually forcing an update on each instance of the add-in).  Just opening the PPTX does not gather the latest PBI data.  Perhaps this too will get better with time.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.