Forum Discussion
Automating Power BI Viewer Role Assignment After Azure Purview Approval
Hello everyone!
In my organization we use Azure Purview to manage access requests for our Power BI reports. Our current flow is:
A user requests access to a data product (Power BI report) from Purview.
I approve the request in the Purview portal.
Although the user now has metadata-level access in Purview, to actually view the report they must click “Open in Power BI (Fabric)”—and that only works if I manually add them as Viewer to the workspace or app.
This manual step is very tedious when there are dozens of requests per day. I’m looking for ideas to automate it so that, upon approval in Purview, the user is granted the Viewer role on the Power BI workspace/app for that report without any manual intervention.
Has anyone implemented something similar or knows of an out-of-the-box approach? Perhaps a Purview extension (even in preview), third-party tool, or community solution that automates this provisioning?
Thanks in advance for any pointers or examples!
Agree current functionality is quite useless. Will not go live towards end-users with Purview before a solution exists.
The https://cdn-dynmedia-1.microsoft.com/is/content/microsoftcorp/microsoft/final/en-us/microsoft-brand/documents/MS-Purview-Data-Governance-Roadmap-detailed.pdfstates:
As a data product owner, I can set up customizable workflows for data product access and use Power Automate connector to connect with other applications.
Planning for private preview is Q2, General availability Q3.
This feature will probably help to realize most of the functionality you are looking for.
I've also heard that the official API for the Unified Catalog side is coming soon, though I don't know timelines and don't have any expectations.
Until then, you wait, or try to use the https://github.com/olafwrieden/unifiedcatalogpy. This also doesn't have requests yet though.
5 Replies
SitaDMicrosoft
Nai_edodo - We will have a Power Automate connector coming up shortly in preview so you can automate your access grants using any of the connectors in the Power Automate library. We will also have incremental advancements in the workflows solution. Are you primarily focused on PowerBI/Fabric?
Hi SitaD, thanks for your reply.
Yes. We're currently primarily focused on PowerBI/Fabric, thats why this solution will be very handy.
I would like to take this chance to ask few questions relating to some BLOCKER in Purview.Lineage Limitation: We've encount limitation on lineage for datasets (Power BI Semantic Models) with more than 200 columns. When we first ran the Purview Data Map Scanner against our finance semantic model, it failed once the total column count across all tables exceeded roughly 500 columns.
¿Do you know why this happens?Classifications: Is it possible to delete the default classification list provided by Microsoft Purview when they are useless or at least avoid them to be used during a full scan ? ¿I've been suggested to use custom classification instead, but I want to see if there's other options out there.
Thanks in advance for you time.
Agree current functionality is quite useless. Will not go live towards end-users with Purview before a solution exists.
The https://cdn-dynmedia-1.microsoft.com/is/content/microsoftcorp/microsoft/final/en-us/microsoft-brand/documents/MS-Purview-Data-Governance-Roadmap-detailed.pdfstates:
As a data product owner, I can set up customizable workflows for data product access and use Power Automate connector to connect with other applications.
Planning for private preview is Q2, General availability Q3.
This feature will probably help to realize most of the functionality you are looking for.
I've also heard that the official API for the Unified Catalog side is coming soon, though I don't know timelines and don't have any expectations.
Until then, you wait, or try to use the https://github.com/olafwrieden/unifiedcatalogpy. This also doesn't have requests yet though.
Hi Rik,
Thanks for your quick and clear respond, the roadmap document was very useful to see future updates.
Can I ask where i could be informed about this updates? I always find myself jumping from website to website everytime I want to know what's new.
Btw, this Automating workflows it will be very nice.Hi Nai,
Unfortunately there is no one single way to get all updates, what I do is the following:
- Check this page: https://learn.microsoft.com/en-us/purview/whats-new
- Follow people that work in Purview on LinkedIn. This group is a good start: https://www.linkedin.com/groups/9865515/
- A Microsoft Customer Connection Program exists, focused on entire Purview suite. You need to work in a professional organization with an NDA to join. Ask your Microsoft contacts for more information.
Hope this helps!
Best,
Rik
