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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
wynhopkins
Most Valuable Professional
Most Valuable Professional

power bi publisher addin disappears each time I close Excel

Does anyone else have this issue in Excel?

 

I've just installed the latest version incase that was the issue.  Still no luck

 

I'm on 64 Bit Office Excel 2016   version 1609 Build 7369.2038

MVP | Author of Power BI for the Excel Analyst | Speaker | Power BI & Excel Developer & Instructor | YouTube- 5 million views | Fan of Power Query & XLOOKUP | Purpose: Making life easier for people through applying and sharing knowledge.
3 REPLIES 3
acrigger
New Member

Yes, this same behavior was happening on my workstation.

 

The following changes to the registry resolved the issue for me.

 

1) Regedit from the command line 

2) Navigate to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins\MicrosoftPowerBI.Client.ExcelAddIn

3) Modify the LoadBehavior

4) Change 'Value Data' from 0 to 3

 

Hope that helps,

wynhopkins
Most Valuable Professional
Most Valuable Professional

Thanks for the reply,  I'll try and get our IT guys to sort this.

 

Shame it's necessary

MVP | Author of Power BI for the Excel Analyst | Speaker | Power BI & Excel Developer & Instructor | YouTube- 5 million views | Fan of Power Query & XLOOKUP | Purpose: Making life easier for people through applying and sharing knowledge.
acrigger
New Member

Hello,

 

I was encountering this same issue with the Power BI Publisher for Excel plug-in.  I went into the registry to change the load behavior and it resolved it for me.

 

1) Regedit

2) Navigate to thHKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins\MicrosoftPowerBI.Client.ExcelAddIn

3) Modify the LoadBehavior

4) Change 'Value Data' from 0 to 3

 

Hope that helps, 

 

Adam

Helpful resources

Announcements
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!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors
Top Kudoed Authors