Unable to Install Excel Publisher

[wchung]

Hello,

I've had connection issue after installing the latest Excel publisher, so I removed the add-in (from excel options) and re-installed the previous version, hoping that it will revert everything. Unfortunately it didn't work and I lost the publisher in the ribbon nor is it available in the COM Add-in list.

So to summarize the publisher is installed on my compuer (I can see it in the install/uninstall screen from control panel), but I can't see or select it from Excel.

Is there any way I can enable it in Excel?

Thank you for the help.

[gvolst]

I installed the 32 bit version for office 2016 32 bit and that worked fine.

However, I uninstalled both products (publisher and office) and installed the office 2016 64 bit version.

When I'm trying to install the publisher 64 bit version I'm receiving the message that it requires Microsoft Excel 2007 or above.

Could some give me a hint how I'm able to solve this?

I tried restarting my machine and removed the registery key for Power BI Publisher, but without success.

Update 2018-01-08: I reinstalled office 2016 64 bit (en-us) and now the installation of Publisher went succesfull.

[v-yuezhe-msft]

@wchung,


In your scenario, please uninstall publisher for excel in control panel, reboot your machine and re-install Excel publisher. Make sure that you installl the correct version of publisher(32 bit/64 bit). If you still get issues, please post the full error message.

Alternatively, you can use Analyze in Excel feature instead to view and interact with Power BI dataset in Excel.

Regards,
Lydia

[wchung]

Hi Lydia,

I followed your instructions but still no luck with the issue. I'm still not able to see the Excel add-in. Below is the screen after I re-installed (publisher add-in not available in Excel) and the error message when I try to use the report (unable to connect to data source).

Thanks for your help.

 

[v-yuezhe-msft]

@wchung,

What is the version of your Excel? Are you able to use Analyze in Excel feature?

Regards,
Lydia

[wchung]

It's Excel 2013 (15.0.4953.1000).

When I use Analyze in Excel from BI screen, it opens up Excel and display the same error message I posted.

Thanks.

[v-yuezhe-msft]

@wchung,

Have you downloaded the latest Analyze in Excel update?

Regards,
Lydia

[wchung]

Hi Lydia,

I can see the Add-in now after windows update. But there's still the connection issue. I attached the screen that shows the error message and add-in version number. The error message pops up after I try to establish a new connection to the BI dataset.

Thanks,

Helen

[v-yuezhe-msft]

@wchung,

Are you able to use "Analyze in Excel" feature? Please take a look at the following similar thread.

https://community.powerbi.com/t5/Issues/PowerBI-Publisher-Issue-on-office-365-after-update-of-office...

Regards,
Lydia