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

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,

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
Europe Fabric Conference

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors