Reply
Frequent Visitor
Posts: 9
Registered: ‎10-13-2016

power bi publisher for excel runtime error

Power BI publisher for Excel does not start

 

 

When I try to load it i get this message:

"Load Behavior: Not loaded. A runtime error occurred during the loading of the COM Add-in"

 

I have tried repairing my office installation and re-installing the Power-bi publsiher for Excel.

It shows as inactive in the add-ins.

 

I'm running a 32-bit version of Office and the add-in.

 

Super Contributor
Posts: 883
Registered: ‎06-09-2016

Re: power bi publisher for excel runtime error

Are you using Excel 2013??

Moderator
Posts: 4,578
Registered: ‎03-10-2016

Re: power bi publisher for excel runtime error

[ Edited ]

Hi @dmacdonald,

Firstly, please ensure that you are using Microsoft Excel 2007 or later version as Power BI publisher for Excel is an add-in you can use with Microsoft Excel 2007 and later.

Secondly, according to the above error message, Power BI publisher for Excel is not enabled correctly. Please check out “COM Add-Ins” dialog in Excel following the steps below.

1. Open Excel Options dialog (File->Options) and navigate to Add-Ins tab.
2. Normally Power BI publisher for Excel should show up in the “Active Application Add-ins” list, if the Power BI publisher for Excel add-in is disabled due to any reasons, please select the “COM Add-ins” from the Manage dropdown, then click Go. In the COM Add-Ins dialog box, select the check box next to the disabled Power BI publisher for Excel Add-in.

Thirdly, disable any antivirus program and disable other Excel Add-ins, then check if you can load Power BI publisher for Excel successfully.



Thanks,
Lydia Zhang

Frequent Visitor
Posts: 9
Registered: ‎10-13-2016

Re: power bi publisher for excel runtime error

I disabled all the other add-ins, I repaired office 2016 again.

I unistalled and reinstalled Power Bi publisher.

I shut off the anti-virus.

 

I still get the same error when I try to enable the  add-in

Moderator
Posts: 4,578
Registered: ‎03-10-2016

Re: power bi publisher for excel runtime error

[ Edited ]

Hi @dmacdonald,

Are you able to use Power BI publisher for Excel in other computer? Also please open registry editor and navigate to “HKEY_CURRENT_USER\Software\Microsoft\Power BI Publisher for Excel”. Here is how this registry key looks like after I installed Power BI publisher, check if your registry key is different from mine.

1.PNG

 

Thanks,
Lydia Zhang

Frequent Visitor
Posts: 9
Registered: ‎10-13-2016

Re: power bi publisher for excel runtime error

Mine are not nything like that:

 

There is nothing in

“HKEY_CURRENT_USER\Software\Microsoft\Office\” 

for Power BI

 

There is an entry in

“HKEY_CURRENT_USER\Software\Microsoft\Power BI Publisher for Excel”.

WIth only and UserInstallID set

 

 

Moderator
Posts: 4,578
Registered: ‎03-10-2016

Re: power bi publisher for excel runtime error

[ Edited ]

Hi @dmacdonald,

According to your registry key, the Power BI publisher for Excel is not properly installed on your current machine. Have you tried to install Power BI publisher for Excel in other computer and check the result? 

Thanks,
Lydia Zhang

Frequent Visitor
Posts: 9
Registered: ‎10-13-2016

Re: power bi publisher for excel runtime error

[ Edited ]

I'm evaluating this as a BI product that I will roll out to 60 users.

We are using the latest versions of Office365.

 

My IT group would kill me if a picked one that won't install and reports no errors and no logs of any problems.

I've put a couple hours into this already and have gotten nowhere.

I can't do this for 60 people or to them.

 

This is just not ready for deployment yet.

 

 

 

 

Moderator
Posts: 4,578
Registered: ‎03-10-2016

Re: power bi publisher for excel runtime error

[ Edited ]

Hi @dmacdonald,

As your post, the correct registry key entry is HKEY_CURRENT_USER\Software\Microsoft\Power BI Publisher for Excel .

What is your OS? Could you please share me the version information of Excel? You can check my Excel version in the following screenshot.
1.PNG

Thanks,
Lydia Zhang

Frequent Visitor
Posts: 9
Registered: ‎10-13-2016

Re: power bi publisher for excel runtime error

Windows 10

 

excel.JPG