cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
fabienturcotte Frequent Visitor
Frequent Visitor

Sharing a PowerBI Workspace to AAD Group for Embedding via JS API

Hi all, 

 

We are in the process of integrating an Embedded PowerBI Report to Salesforce using the JS API. Our setup is the following:

 

- Users are already using Azure AD for SSO in order to access the application. We also use AAD for user provisioning. We have several AAD groups (fed by AD) replicating to SF for which it also manages the Roles/Profiles. That part works fine. 

 

- We have created a Premium Workspace with dedicated capacity, in which we have created a Report.

 

- We have created a App Registration in Azure, to which we assigned the AAD groups. That part is used to acquire the AAD token to use with the JS API.

 

- For testing, we have added one team member in the Workspace as a "member"

 

- On the Salesforce side, we have injected the appropriate code as per documentation on JS API for Embedding

 

When the user launches the Salesforce page, the AAD auth prompts, token is acquired and report is shown. It works fine.  (Yay!) 

 

Now the "problem" we are trying to solve is to share the Workspace with our AAD groups. We cannot possibly manage individual access to that Workspace.

 

 

I've read the @sqlchick post https://www.sqlchick.com/entries/2016/8/6/managing-members-in-a-power-bi-group-workspace

 

But I'm wondering if there has been some development ever since. Is it still the only way to go?

 

Using this option, we would then to create an O365 group, to which we assign our AAD groups. Then a PowerShell batch script to sync the users of these AAD groups to the O365 group.

 

Thanks,

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-jiascu-msft
Microsoft

Re: Sharing a PowerBI Workspace to AAD Group for Embedding via JS API

Hi @fabienturcotte,

 

Adding other groups is a feature of the new App Workspace which is under preview. Please refer to ervice-create-the-new-workspaces.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Microsoft v-jiascu-msft
Microsoft

Re: Sharing a PowerBI Workspace to AAD Group for Embedding via JS API

Hi @fabienturcotte,

 

Adding other groups is a feature of the new App Workspace which is under preview. Please refer to ervice-create-the-new-workspaces.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Microsoft v-jiascu-msft
Microsoft

Re: Sharing a PowerBI Workspace to AAD Group for Embedding via JS API

Hi @fabienturcotte,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
fabienturcotte Frequent Visitor
Frequent Visitor

Re: Sharing a PowerBI Workspace to AAD Group for Embedding via JS API

Works like a charm and it is EXACLTY what we needed.

 

A new workspace has been created as Premium, content moved from the previous one to this one, and access can now be managed using AAD groups instead of individual users or o365 groups.

 

Thanks,

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors