Azure Security Group Automation [Guest Post]

Mission Statement

In this blog post by our guest author (@islamtg) we are going to discuss how to automatically update an Azure AD Security Group. This can be useful for something like Power BI where we have a security group that has specific permissions on a service. Through this will will try to address the following topics:

• Eliminating the manual task of adding users to a security group.
• Eliminating the process of manually cleaning up inactive users and invalid (or no longer valid) emails addresses.
• Create an email clean up list that can be sent to the admins on a daily basis which can then be automated to clean up bad emails.
• Creating an automated process for multiple security groups.
  • Create a read only security group on a particular service, a server admin security group.
  • Add users to a group that is assigned a specific license.

 

The Power of DevOps and Deploying Power BI reports to different Environments [Guest Post]

We are very happy to publish our very first Guest Post by Islam El-Ghazali (@islamtg)!

Mission Statement

We are trying to create a source control versioning process for our Power BI Reports, to allow us to publish our reports and revert to previous versions.

• Eliminate the step of saving multiple Power BI Reports on the machine as v1, v2, …, etc.
• Allow us to do continuous integration and development for the reports on multiple workspaces, i.e. DEV, QA, PRD with minimal effort.
• Use Azure DevOps to make this a more automated process while have control over what gets pushed to prod.