Transaction Batching in SQL Server
This post explores the concept of transaction batching in SQL Server as a solution to efficiently manage resources and avoid unnecessary rollbacks.
Transaction Batching in SQL Server Read More »
Delete multiple records in PowerApps using Remove function
Remove function deletes records from a data source. This article describes how to delete multiple records in PowerApps using Remove function.
Delete multiple records in PowerApps using Remove function Read More »
An error occurred in the microsoft .net framework while trying to load assembly id 65536 SSIS
Error An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:System.IO.FileLoadException: Could not
Export and Import PowerApps Package
Microsoft PowerApps simplifies app creation with templates, connectors, and third-party apps. Its popularity among developers is due to its ability to perform CRUD operations and support most data sources, including on-premises. Once the app is developed, you may want to migrate it to another environment like dev to test. This article describes how to export
Export and Import PowerApps Package Read More »
Power BI row level security – Step by step guide
Power BI offers feature to implement role based access control. This article will describe how to implement RLS in Power BI.
Power BI row level security – Step by step guide Read More »
Open DACPAC File in Visual Studio
DACPAC file can be used to deploy database code using CICD tools like Azure DevOps. Learn how to open DACPAC file in Visual Studio.
Open DACPAC File in Visual Studio Read More »
Connect to Azure Analysis Services from Power BI
This article describes how to connect to Azure analysis services from Power BI using Azure Active directory authentication with MFA.
Connect to Azure Analysis Services from Power BI Read More »
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 is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset’s settings page and enter credentials for all data sources. Then reactivate scheduled refresh. Solution Follow the below steps to fix
Scheduled refresh is disabled because at least one data source is missing credentials. Read More »
Show seconds as hh mm ss in Power BI
DAX offers a wide range of functions to perform complex calculations, This article describes how to show seconds as hh mm ss in Power BI.
Show seconds as hh mm ss in Power BI Read More »
Find Stored Procedures related to Table in SQL Server
This guide will help you find SP related to table in the SQL Server database or Azure SQL database using client tools like SSMS.
Find Stored Procedures related to Table in SQL Server Read More »