Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Fabric Community site will be in read-only mode on Monday, Feb 24 from 12:01 AM to 8 AM PST for scheduled upgrades.

Reply
royce4
Frequent Visitor

Excel worksheet using Power BI data model triggers com error

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. 

royce4_1-1739399830752.png

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.

1 ACCEPTED SOLUTION

That fourth bullet point resolved it.

View solution in original post

5 REPLIES 5
v-saisrao-msft
Community Support
Community Support

Hi @royce4,

 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @royce4,


I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.

v-saisrao-msft
Community Support
Community Support

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. 

  • Open Excel and navigate to File > Account. Click Sign Out, close Excel completely, then reopen it. Sign in again and attempt to reconnect. 
  • Please sign in to Power BI Service and attempt to open the dataset directly. If you encounter any issues, it is likely an account-related problem rather than an Excel-specific one.     
  • Navigate to the Power BI workspace where the dataset is stored and verify that you still hold the admin role for the workspace. Ensure that your Power BI license is active and that your organization’s subscription has not expired. 
  • Remove & Re-add the Dataset Connection in Excel, navigate to Data > Queries & Connections > Manage Data Model. Remove the current Power BI dataset connection and reconnect through Get Data > Power BI Datasets. Go to Data > Get Data > Data Source Settings, locate the Power BI data source, select Edit Permissions, and re-enter your credentials. 
  • Verify if the authentication token has expired.  
  • Some organizations restrict logins based on device, location, or security settings. Please consult your IT administrator to ensure your access is not restricted. Check Multi-Factor Authentication (MFA). If MFA is enabled, ensure Excel supports it and verify if your organization requires an app password. Contact IT if you suspect MFA settings are blocking the connection. 

 

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.

 

That fourth bullet point resolved it.

Akash_Varuna
Responsive Resident
Responsive Resident

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors