In my previous blog on Data Factory, I have explained how to extract data from Azure SQL Database (Source) to Azure SQL Database (Destination) where I uploaded the output of On-Premise data into a Blob Storage and then use the Azure Data Factory to load data from Blob Storage to Azure SQL Database. There are several ways… Continue reading Load data from SQL Server On-Prem to Azure SQL Database using Azure Data Factory

With the wide adaption of Power BI, reports from the data extracted various data sources and was shown at an enterprise level, this gave an important need of reporting model to be at an enterprise level. One of such enterprise level reporting features being providing data security among the users, if a particular region manager… Continue reading User-Based Security Inside Power BI Dashboard