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.
Hello, I have a use case where I want to accomplish the following…
1. Create a data model
2. From that model create a report with RLS
3. Publish that report to a workspace for users. This is what we will call the global standard report.
4. From that report, have a set of power users from around the globe be able to create additional reports off of that report and publish them for their teams (we will call this the regional reports).
What I have found is…
If I publish the report to a workspace, I can grant the power users to connect to the data model with RLS. The challenge with this solution is you can only publish to the same workspace (as far as i can see). This won't work for us because the regional reports are specific for the regions and we don't want to clutter the global workspace with other people's content.
Is there a way to allow them to somehow publish this to another workspace? if not, does anyone have experience sharing datamodels with this scenarios
Note, i have looked at data flows. The downside that i see is 1) the dataflow does not have RLS (though i heard a rumor it may be coming) and 2) data flow is just the source table, not a data model. But i am also not too familiar with data flows yet, so i may be missing something
thank you.
@GilbertQ Thank you for the feedback. I did set the people up for build permission. They can connect to the data model, but it only allows them to publish to the same workspace. How do you allow them to save it to another workspace?
@GilbertQ wrote:
Hi there
This can certainly work. From your Global Workspace, you can create an App and allow the users who are part of the app to have the Build permission.
When a user has a build permission this will allow them to connect to the Power BI Dataset from Power BI Desktop using the Shared Dataset.
All the above will honour the RLS that you have set up.
Here are more details: https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions
@GilbertQ wrote:
Hi there
This can certainly work. From your Global Workspace, you can create an App and allow the users who are part of the app to have the Build permission.
When a user has a build permission this will allow them to connect to the Power BI Dataset from Power BI Desktop using the Shared Dataset.
All the above will honour the RLS that you have set up.
Here are more details: https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions
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.