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.
