power bi publisher for excel runtime error

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