cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chaz2jerry
Advocate III
Advocate III

XMLA endpoint usage by external user

According to the article below, we can have external users connect to XMLA endpoint of premium datasets.  So in theory we can use Tableau desktop, connect to a shared dataset as directquery / live connection (similar to AAS/SSAS) and create reports.  

https://docs.microsoft.com/en-us/power-bi/admin/troubleshoot-xmla-endpoint

So I have conducted a test with an external user, using Tableau Desktop (as the external tool) to connect to the XMLA endpoint, but connection is unsuccessful.  Can anyone share their experience and more insight to this use scenario?  Following is the config I used:

  • External user info:
    • user has regular email "john.doe@externalcompany.com"
    • user has guest email "john.doe_externalcompany.com#EXT#@myorg.onmicrosoft.com" in our AAD.  Note the "myorg.onmicrosoft.com" is our tenant name.   
    • the guest user's account has been assigned Premium-Per-User (PPU) free trial license in our "myorg" tenant.  
    • the guest user is also added to the "external user can edit content" security group in tenant admin settings.
  • Premium content info:
    • The PBI dataset is published to a Premium-Per-User workspace.
  • Tableau desktop connection info:
    • The user used Microsoft Analaysis Service connector, and installed the two related drivers in advance.
    • For server address, using XMLA endpoint address "powerbi://api.powerbi.com/v1.0/myorg.onmicrosoft.com/test PPU" from the PPU workspace info.
    • we tested two authentication options:
      • Test 1: used "john.doe@externalcompany.com" for username,  and the user's normal O365 password.
      • Test 2: used "john.doe_externalcompany.com#EXT#@myorg.onmicrosoft.com" for username,  and the user's normal O365 password.
2 REPLIES 2
collinq
Super User
Super User

Hi @chaz2jerry ,

 

I do not know much about XMLA but I did find these two articles about how this should be working.  Let us know if that helped!

Power BI open-platform connectivity with XMLA endpoints public preview | Microsoft Power BI Blog | M...

“Live” Web Services Connections in Tableau | Tableau and Behold!

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Thanks @collinq  I checked the two articles but they don't seem to solve my scenario.  The first article includes documentation for XMLA Endpoint, but doesn't specify how to connect to it from external B2B user.  

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors