Forum Discussion
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
- Connecting with Azure Active Directory B2B
- With support for Azure Active Directory (Azure AD) business-to-business (B2B) in Power BI, you can provide external guest users with access to datasets over the XMLA endpoint. Make sure the Share content with external users setting is enabled in the Power BI Admin portal. To learn more, see Distribute Power BI content to external guest users with Azure AD B2B.
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 "[email protected]"
- 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 "[email protected]" 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
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!
“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!
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.
