Get Data from Power BI using Microsoft Excel

[NealQu]

Hi Everyone,

I am currently using Microsoft Excel. When trying to Get Data from Power Platform -> Power BI I get the following error.

============================================================================
Sign in to view your datasets

An error occurred when trying to sign into Power BI. Please ensure you are signed into Excel with an organizational account.

Please try again later.

If you contact support, please provide these details.

Signin unsuccessful - general error

Time: Fri, 28 Jun 2024 12:30:37 GMT

Version: 1.273.0

==================================================================

The OS is Windows 11.

I tried the following troubleshooting steps.

1. I signed out and signed back in on both power BI and excel and the error still persist.
2. Control Panel > Credential Manager > Windows Credentials -> I checked, and Power BI or Excel is not there to clear.

3. I checked Power BI dataset permissions it redirected me to Microsoft Fabric Free which is not available for my account.

Any advice?

[amitchandak · Accepted solution]

@NealQu , Please check XMLA end-point is enabled in Tenant settings

[NealQu]

Thank you!

[Anonymous · Accepted solution]

Hi @amitchandak ,Thanks for your quick reply, I will add more.

Hi @NealQu ,

1.Please make sure that the account used to log in to Excel is the same as the account used to log in to Power BI Service.

2.Check your license

Power BI semantic model experience in Excel - Power BI | Microsoft Learn

3.The organization’s tenant admin must enable the “Users can work with Power BI semantic models in Excel using a live connection” setting.

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@NealQu , Please check XMLA end-point is enabled in Tenant settings