Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Error while connecting DataSet to Excel


I am trying to connect a DataSet to Excel by my company account. When I open a desktop Excel and choose the Power Bi source, popup shows error with information " GetTenantInfo was unsuccessful ".




I Have tried relog, restart the Excel and whole PC several times without change. I Have similar rights as my colleagues, who are able to add it to Excel. When I add it via second account ( Again the same rights as mine ) and sent the Excel file with created connection to my PC, I am able to refresh the data, but adding a new DataSet stil not working.

Can someone help me with this ?

Community Support
Community Support

Hi @JakubG 


Are you able to log in Power BI Service with the account that failed to connect to a dataset from Excel? When using this account in Power BI Service, are you able to see the dataset you want to connect to? 


Best Regards,
Community Support Team _ Jing

Hi  @v-jingzhang 

Account works perfect in Power BI workspace and desktop.


Hi @JakubG 


So are you able to use the Analyze in Excel feature from Power BI Service? This can also let you use a Power BI dataset in Excel. This may be a workaround. Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn



Best Regards,
Community Support Team _ Jing

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors