PowerBI Excel add-in not working with latest Office update

[trouty74]

Has anyone else had issues connecting with the PowerBI Excel add-in since taking the latest Office update (Version 1709)? Have a number of users experiencing the problem after taking the Office update. Have confirmed with 2 different user laptops that everything working as expected then after taking the Office update and trying to connect getting the error: Can't access the dataset or the report.

[v-yuezhe-msft]

@trouty74,

Please make sure that you download and install the latest version of Power BI publisher for Excel, and ensure that the excel add-in you install matches the bitness version of your Office(32bit or 64 bit).

Regards,
Lydia

[trouty74]

Hi Lydia,

Have tried that many times but tried again with your suggestion. My Office version is 32 bit but tried the 64 bit install and it wouldn't run because it detected I only had a 32 bit install of office. There are now at least 6 users affected by this since installing the latest Office update. Others onsite that haven't taken the Office update are working as normal. 

[trouty74]

Can anybody out there confirm that the 'Power BI publisher for Excel' is working for them on the latest version of Office i.e. version 1709.

[v-yuezhe-msft]

@trouty74,

 I can reproduce your issue after I update Office to 1709. I will report this issue internally and post back once I get any updates.

Regards,
Lydia

[trouty74]

Hi Lydia,

Thanks for that. I logged a premier support call yesterday and the Microsoft support engineer also verified the issue. They were also getting in contact with the product group about the issue.

[v-yuezhe-msft]

@trouty74,

Please use the workaround as described in the following similar thread.

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

Regards,
Lydia

[BFroc]

I'm having a different issue, but with the same service.