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

Azure Data Factory is a Microsoft cloud-based data integration service which helps to transfer data to & from Azure Data Lake, HDInsight, Azure SQL Database, Azure Machine Learning (Cognitive Services), Azure Blob Storage etc. It organizes & automates the movement and transformation of data. Azure Data Factory works across on-premises, cloud data sources as well as SaaS… Continue reading Extract Data and Load 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