Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Error connecting to XMLA endpoint

Submitted by Anonymous on ‎03-28-2019 06:55 AM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
anuarmn
Advocate I
Advocate I
‎03-28-2019 09:00 PM

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

 

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

v-qiuyu-msft
Community Support
Community Support
‎03-31-2019 06:53 PM

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
‎04-01-2019 06:03 AM

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

Idea Statuses