Analyze in Excel - refresh issue, cannot connect to the underlying dataset!!!

[MacJasem]

Hi Guys/Girls

Hope some of can help solving this issue.

I've created a dataset and report in powerbi and then created an Analyze in excel report based on that dataset in PowerBi. Previously i haven't had issues with connection to the dataset and refreshing, but now every time i open the excel file i get these error messages:

1. error message:

2. error message:

This is eventhough my user account (O365 account) has admin rights and the same user has created the workspace, dataset and reports in powerbi. The dataset and report refreshes without any issues in PowerBI service.

Is there something i'm missing here?

[v-jtian-msft · Accepted solution]

Hi,smokeyjoe03 ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hi,@MacJasem .I am glad to help you.
In fact, the problem you encountered has recently been reported by other users, and now the Microsoft development team has noticed the problem and is working on it, I will update this post to let you know if there is any relevant progress.
Same issue:
Power BI connection in Excel - Unable to sign into... - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[MacJasem]

Thanks @v-jtian-msft for the input and info. Yes please let me know when theres any relevant progress in this matter 😊👌

So by your respons i can assume it's a bug?

Br. McJasem

[v-jtian-msft]

Hi,@MacJasem .Thank you for your reply.
Yes, at the moment for this issue, the Microsoft development team is still actively working on it, if there is any news. I will keep you informed.

[MacJasem]

thisis also a error message when i downloade a new Analyze in Excel file from PowerBi service and open it up in the desktop then i get this message:

[smokeyjoe03]

The authentication error may be a red herring, try signing out of and into Power BI and Excel again to make sure, but I've seen this same error when the OLE DB libraries on were out of date after an Excel release.

If anything has been uypdated recently, you may need to download the newer versions of the libraries.

[MacJasem]

Hi @smokeyjoe03 

Thanks for the input 👍i'll try to reinstall excell again and see if it solves the issue.

With regards to signing out of PowerBI and Excel, i've tried that and it didn't help.