Open DACPAC File in Visual Studio
DACPAC file can be used to deploy database code using CICD tools like Azure DevOps….
Connect to Azure Analysis Services from Power BI
This article describes how to connect to Azure analysis services from Power BI using Azure…
Scheduled refresh is disabled because at least one data source is missing credentials.
Error Last refresh failed: 9/4/2023, 2:11:28 PMScheduled refresh has been disabled.Data source error: Scheduled refresh…
Show seconds as hh mm ss in Power BI
DAX offers a wide range of functions to perform complex calculations, This article describes how…
Find Stored Procedures related to Table in SQL Server
This guide will help you find SP related to table in the SQL Server database…
Disable and Enable triggers in Azure Data Factory using PowerShell
This article will provide step-by-step instructions to enable and disable triggers in Azure Data Factory…
Update Secret in Azure Key Vault using PowerShell
This article describes how to update secret in azure key vault using PowerShell using AAD…
Activate and Deactivate Activity in Azure Data Factory
Microsoft recently introduced a feature in ADF to disable activity. This article describes how to…
Automatically Delete Old Files from Azure Storage Account
Follow these quick steps to periodically delete old files from Azure storage account.
Create SSIS Catalog in SQL Server
This article describes step by step approach to create SSISDB under Integration Services Catalog in…
Find deadlock in SQL Server
A deadlock occurs when two or more processes or transactions block each other from continuing…
Principle could not be found or this principal type is not supported
This article describes how to solve error: Principle ‘Data factory’ could not be found or…