Forum Discussion
Helper IIAutomatically provide user access to "Report A" based the access to "Report B"
Hi community,
I hope this email finds you well.
I'd like to ask about the possibility to automate the "Access Approval" to a Ppower bi "Report A", based in the access of that user to a "Report B". Here the details:
Scenario description:
- "Report A" is published on "Worspace Z" (all tables in "import mode")
- "Report B" is published on "Worspace XY" (some tables pulled via "import mode", and some tables pulled from "semantic model of Report A" (live connection - direct query, using build permisisons)
- As you can imagine, when a user with acces to "Report B" wants to see the visuals built wtih tables from "Report A", he gets the error "fetching data for this visual" (because he doesn't have acces to Report A")
- Once "Owner of Report B" contacts to "Owner of Report A" and provide the list of users that need access; the problem is solved.
Question:
- Do you know if exist a workaround to automate the access to "Report A", based on the users list of "Report B"?
- (or a semiautomation process that you have implemented in the past)
I remain attentive to any comment,
Thanks,
Hi Miguel_Rojo
In order for this to work, you'd have to put in some kind of automation for this process to work where you would have to specify the relationship between report A and report B. If you can put that relationship in place, you could then use the power BI rest APIs to see the access that a user has in report A and then grant that access file. The rest API to report B. You could use this doing something like power automaton. that would take a few steps to get it completed, but it could certainly be done. Admin - Reports GetReportUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn
2 Replies
- GilbertQ
Super User
Hi Miguel_Rojo
In order for this to work, you'd have to put in some kind of automation for this process to work where you would have to specify the relationship between report A and report B. If you can put that relationship in place, you could then use the power BI rest APIs to see the access that a user has in report A and then grant that access file. The rest API to report B. You could use this doing something like power automaton. that would take a few steps to get it completed, but it could certainly be done. Admin - Reports GetReportUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Hi Miguel_Rojo,
Thank you for reaching out in Microsoft Community Forum.
Thank you GilbertQ for the helpful response.
As suggested by GilbertQ, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Please continue using Microsoft community forum.
Regards,
Pavan.
