Author Archives: Islam El-Ghazali

About Islam El-Ghazali

My name is Islam El-Ghazali Please visit my LinkedIn Profile to check out my projects. I focus on Big data and programming. I have a passion in Sports Management in particular to Football/Soccer/Futbol

Azure Security Group Automation [Guest Post]

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.
Read the rest of this entry »
Leave a comment

Posted by on December 16, 2020 in Database Administration, Other


Tags: , , , , , ,

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

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.
Read the rest of this entry »

Posted by on November 4, 2020 in power bi


Tags: , , , , , , ,

%d bloggers like this: