Forum Discussion
Automating Power BI Viewer Role Assignment After Azure Purview Approval
- May 08, 2025
Agree current functionality is quite useless. Will not go live towards end-users with Purview before a solution exists.
The Roadmap states:
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 unofficial python wrapper for the API. This also doesn't have requests yet though.
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?
- Nai_edodoMay 22, 2025Copper Contributor
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.