![]() Note for these sections we will be using the enterprise Data Gateway and not the Personal Setup the gateway for Power BI, Power Apps, Power Automate Configure a data Gateway (Optional, only required if data is on-premises.) So we will need an AD admin to make us an owner of the existing group or a newly created group. I will keep the members empty as we can automate the process. When we configure the owners this will be important since you can only be an owner of the group to be able use power automate to update the group. In this case we are create a new Security group we will call it PBI-Auto-Group and we will assign few people to this group. In this section we will look at what is needed for the security group, this will require an AD admin to help create or modify the permissions of the group. GRANT EXECUTE ON OBJECT.Īnd this concludes the SQL portions that are need for the flow. Grant permission to the login to execute the stored proc So the login will look something like the below. We want to create a login or use an existing login that has least privilege permissions on a table, we really just need a login that has execute permissions on a stored proc that does a read on the users table. ![]() Configuration for Power BI, Power Apps, Power Automate.Configure a data Gateway for the Logic App, (Optional, only required if data is on-premises.).Account that has permissions on the Security group to add new members.Well the good news is this will be codeless! We will be using Power Automate to accomplish this which is part of the Power Platform family the same steps can be applied with Logic Apps. Create a least privilege account for read-only purposes in SQL Server that can execute stored procedures.Īs soon as you mentioned automation, the question of how much code comes to mind.Use stored procs to get the data from SQL Server.If you have an existing gateway that is used by Power BI you can potentially reuse that.If you are using logic apps to access data on premises step up a data gateway.If it is in Azure and is a Platform As A Service (PAAS) solution you not need a data gateway.If it is an Infrastructure As A Services (IAAS) solution you will still need a data gateway.If the data is on premises, you will need to setup an azure data gateway for Logic apps.If you are going to use Logic apps, please note.There will be a workaround architecture that will use SSIS and SharePoint Online this will help If you don’t have a Premium license for Power Automate or you cannot create Logic Apps due to cost or other limitations. Some of the actions will require Premium licensing for Power Automate.We will be using Power Automate, but these concepts can still apply to Logic Apps.Updating Security Groups manually can become a tedious and time-consuming task, therefore why not automate it? It can also cause delays for getting proper access for individuals or even organizations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |