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...
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. 

      • dmacdonald's avatar
        dmacdonald
        Advocate I
        9 years ago

        Looks to me like we are still just guessing what the problem is.

         

        Well Powerbi is an msi installer so the instructions actually won't work as described.

         

        Regardless, I ran the msi in an adminstrator elevated environment and there is no change.

         

        Looks like a great tool, but I'll wait to roll it out in my organization once it's stable and reliable,

         

         

        I think the bigest issue here is that the error messaging and loging is, in a word, useless.

        And useless messages are not going to help my IT group install this for 100 users.