cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheOckieMofo
Resolver II
Resolver II

XMLA Endpoint Error

Hello PBI Nation,

 

I'm having a heck of a time getting the new XLMA endpoint working. I've read several articles about it, but I'm not getting it to work, whether I use SSMS 18.0 RC, Excel, or PBI report Builder. I am the admin for my company's Power BI Premium node and it is set to "1" in order to allow this. I have several datasets on the premium node under "classic" workspaces as well as one under a "new" workspace. I can't connect to either. I keep getting the error:

TITLE: Connect to Server
------------------------------

Cannot connect to powerbi://api.powerbi.com/v1.0/myorg/VIPER - Sales Managers.

------------------------------
ADDITIONAL INFORMATION:

The remote server returned an error: (401) Unauthorized.

Technical Details:
RootActivityId: 3faf2e5a-1f4c-4287-b839-8f5f0627be4c
Date (UTC): 4/21/2019 8:13:49 PM (Microsoft.AnalysisServices.AdomdClient)

------------------------------

The remote server returned an error: (401) Unauthorized. (System)

------------------------------
BUTTONS:

OK
------------------------------

 

I am at a loss. I feel like I'm doing everything right, so help me out. What am I missing? The dataset is in Power BI. Our tenant is set to 1 allowing an XMLA connection. I am an admin on the tenant as well as for the workspace. So what gives?

 

Andrew

1 ACCEPTED SOLUTION

I commented on Chris Finlan's blog about this topic and he directed me here:

 

https://powerbi.microsoft.com/en-us/support/

 

Looks like xmla is currently down. Bummer as I was very excited to start kicking the tires on this feature.

View solution in original post

2 REPLIES 2
mawaisaslam
Regular Visitor

I am also facing the same issue. Please help if you have already solved it.

I commented on Chris Finlan's blog about this topic and he directed me here:

 

https://powerbi.microsoft.com/en-us/support/

 

Looks like xmla is currently down. Bummer as I was very excited to start kicking the tires on this feature.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors