Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have my azure subscription in DomainA.com and my Powerbi.com in a DomainB.com.
I have :
1. Created a guest invite to user x.y@domainB.com in domainA.coms Azure AD.
2. Then I have tried to add x.y@domainB.com to a role in Azure Analysis services (domainA.com)
3. I cannot find x.y@domainB.com but I find x.y_domainB.com#EXT#@domainA.onmicrosoft.com
4. I add this account to the role
5. I cannot see any model in either excel or PowerBI.
I can put a manual entry in the analysis services role and that works. But I would like to use AAD groups in the role and handle all administration within AAD. Does anyone have any ideas?
Thanks in advance!
Solved! Go to Solution.
I think I found the answer. I needed to create a new SSAS Service in Azure. Then everything worked smoothly. I think that my old SSAS enviroment has not been patched correctly by Microsoft
HI @tysklind,
I'd like to suggest you take a look at official document.
Considerations and Limitations
As document said, current these guest users can't edit on external workspaces.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft,
Thanks for your reply.
When I'm creating the the reports and connecting to the data source (AAS), i'm using an account from domainA (the domain that holds azure/analysis services). That works fine.
When I publish the report to domainB's PowerBI. I cannot access the data.
Is B2B only for enviroments where PowerBi and analysis services is in the same domain and you are inviting external persons to that domain?
HI @tysklind,
>>Is B2B only for enviroments where PowerBi and analysis services is in the same domain and you are inviting external persons to that domain?
According to your description, I think it may related to 'effective user name'. After you setting guest users, power bi will assign these users as'x.y_domainB.com#EXT#@domainA.onmicrosoft.com'.
In my opinion. I'd like to suggest you try to setting UPN to replace specific string(_domainB.com#EXT#) to help azure find out correspond effective user name.
User Principal Name (UPN) Mapping in Power BI
Regards,
Xiaoxin Sheng
I think I found the answer. I needed to create a new SSAS Service in Azure. Then everything worked smoothly. I think that my old SSAS enviroment has not been patched correctly by Microsoft
Hi @tysklind
This can be done, and I would suggest following this video from Guy In a Cube
https://www.youtube.com/watch?v=Q9f46gAv3Fo&list=PLv2BtOtLblH19Pp_DYpVXYUI0m8D0nDgd
You can also do it by adding the guest user into an Azure Active Directory Security Group, and then putting this group into Azure Analysis Services?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
18 | |
17 | |
16 | |
8 |