Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.