Forum Discussion

dmacdonald's avatar
dmacdonald
Advocate I
9 years ago

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 tri...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

dmacdonald's avatar
dmacdonald
Advocate I
9 years ago

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.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.


    Thanks,
    Lydia Zhang

    • dmacdonald's avatar
      dmacdonald
      Advocate I
      9 years ago

      Windows 10

       

      • Vicky_Song's avatar
        Vicky_Song
        Impactful Individual
        9 years ago

        dmacdonald, could you please follow steps in this blog for the trouble shooting steps about how to deal with the "A runtime error occurred during the loading of the COM Add-In" error? 

         

        In addition, in this article which discusses workaround of the same issue in OneNote is to run the addin with Administrator permission. Please also try it to see whether it works in Excel.