Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have a colleague who has an Excel workbook that connects to a data set in the Power Bi service and he gets an error now when connecting to it. He has connected to it before maybe around a month ago without getting an error. He has a Fabric license and has Admin permissions for the workspace the datasets reside it- in fact he created them.
COM error: COM error: Microsoft.AnalysisServces.AzureClient, Can't obtain the account information for <<email address>> while trying to refresh the token.
I have little experience using Excel to connect to Power Bi datasets so this 'token' error seems a bit unusual.
Would this something that can be resolved by editing the data source permissions in Excel- like re-entering them?
Or is this more a different issue?
I have not found any similar issues around this error message.
Looking for any advice.
Thanks in advance.
Hi @royce4,
Thank you for reaching out to the Fabric support forum with your query regarding the COM error encountered when connecting your Excel workbook to a Power BI dataset. I understand how frustrating this issue can be, especially since it was working fine a month ago.
Please go through the below link for additional information:
Troubleshoot the connection from Excel to Power BI data - Power BI | Microsoft Learn
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.
Thankyou.
Hi @royce4 , It seems to be like authentication error could you try going to data source settings andclear them and login once more and try connecting to dataset ..... If the issue is still there try confirming if the user has access towards the file now also or it has been removed
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
User | Count |
---|---|
19 | |
10 | |
10 | |
9 | |
7 |