![]() Note if you already have a data gateway created for Power BI you can skip the below steps, and if you are using logic apps you can take a look at the section for Logic App to see how to setup the data gateway for logic apps. 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. ![]() ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |