Forum Discussion
Analyze in Excel - refresh issue, cannot connect to the underlying dataset!!!
- Anonymous1 year ago
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
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.
- MacJasem1 year agoAdvocate II
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.