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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Error connecting to XMLA endpoint

We're trying to connect to our dataset using the XMLA endpoints that were published, but I'm experiencing an error "Error Connecting: The remote server returned an error: (400) Bad Request".

 

We're connecting from latest DAX studio using the connection string "powerbi://api.powerbi.com/v1.0/myorg/Demo". Demo is a premium workspace and has valid datasets in it.

 

Has anyone been able to connect using the XMLA endpoints successfully?

 

Thanks,

Scott

Status: New
Comments
anuarmn
Advocate I

powerbi://api.powerbi.com/v1.0/myorg/Demo

 

You have to change "myorg" to your company name + .com

v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

There are many requirements and settings when using XMLA endpoint. The connected dataset needs to be resides in a premium workspace, Analyze in Excel feature and XMLA endpoint must be enabled. For more information, please go through this blog

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable

Hi Quiyun,

 

thanks for the update. We discovered that we had disabled the Analyze in Excel feature while working on a ticket. Once that was re-enabled we are able to connect.

 

Thank you!

Scott