Forum Discussion
data democratization using power bi
Hi SaiTejaTalasila ,
please see below steps which I am planning for this process. we currently use service now, sharepoint and JIRA tools. please let me know if below process looks fine to you. i hope below should be doable
1. we will pull all metadata (report, dataset and workspaces) from Power BI using rest api and store in snowflake database
2. power bi report will be created using database mentioned in previous point
3. report will be converted to an app
4. app will be assigned to organization level group where all employees can see that app
5. subcribe button will be provided in front of each report in power bi app
6. once user click on subscribe then service now incident will be raised, integration between power bi and service now will be done using power automate
7. report owner will receive email of report name and type of access (read/write)
8. report owner will manually assign user to a report or workspace or share dataset with read or write access
Hi lbendlin ,
Even that works.if possible you can improve the process once the request is raised in service now it should submit a request to a Sailpoint iiq group and the group owner will receive access request once the approval is done by owner the user will get access automatically to the power bi app.
Step7 and step8 you can try to automate it .
2nd option -
report owner gets the user email and access type in an excel file by the end of every day and he can use power shell and rest API commands and provide the access with in less than 5mins for multiple users.
I hope it will be helpful.
Thanks,
Sai Teja