Forum Discussion

tysklind's avatar
tysklind
Regular Visitor
8 years ago
Solved

RLS, B2B and Analysis services issue

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 [email protected] in domainA.coms Azure AD. 2. Then I have tried...
  • tysklind's avatar
    tysklind
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI tysklind,

 

I'd like to suggest you take a look at official document.

 

Considerations and Limitations

  • When you invite guest users that are using personal email accounts such as gmail.com, outlook.com, or hotmail.com you can follow this embedded video to see an example of how a user would sign up.
  • External B2B guests are limited to consumption of content only. External B2B guests can view apps, dashboards, reports, export data and create email subscriptions for dashboards and reports. They can't access workspaces or publish their own content.
  • This feature is not currently available with the Power BI mobile apps. On a mobile device, you can view Power BI content shared using Azure AD B2B in a browser.
  • Using guest users with Power BI is not supported within sovereign clouds (government).

 

As document said, current these guest users can't edit on external workspaces.

 

Regards,

Xiaoxin Sheng

tysklind's avatar
tysklind
Regular Visitor
8 years ago

Hi Anonymous,

 

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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • tysklind's avatar
      tysklind
      Regular Visitor
      8 years ago

      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