Open ispac File in Visual Studio
This article describes how to Open SSIS Package from ispac file or from Integration Services Catalog in SQL Server Data tools.
Open ispac File in Visual Studio Read More »
Create DACPAC from SQL Server Database
DACPAC file is essential when migrating your on-premise SQL Server database to Azure. This is because Azure SQL database does not support regular SQL Server backups (.bak) files for restorations and requires a separate type of backup file called BAKPAC – Data-Tier Application Export (.bacpac file). Moreover, to create a BACPAC file, you must first create a DACPAC file to ensure that your database is ready for a BACPAC export. This article will show how to take a DACPAC extract of an on-premise SQL Server database.
Create DACPAC from SQL Server Database Read More »
Export Measures From Power BI Desktop
This article describes how to export measures from Power BI Desktop using the Power BI template.
Export Measures From Power BI Desktop Read More »
Kafka Streaming vs Spark Streaming
Kafka Streams and Spark Streams are potent tools for real-time processing, Here are the key differences Kafka Streaming vs Spark Streaming.
Kafka Streaming vs Spark Streaming Read More »
How To Test RLS in Power BI Service
Access to a specific user can be restricted at various levels to protect data. It is essential to test whether the security implementation is working as expected. In that case, you might try if the report shows relevant data to a particular user via a specific Power BI role. This article describes how to run Power BI report as a different user to test row-level security.
How To Test RLS in Power BI Service Read More »
ClickOnce does not support the request execution level ‘requireAdministrator’
ClickOnce does not support the request execution level requireAdministrator. However, we have a workaround to fix this problem. This article describes how to achieve it.
ClickOnce does not support the request execution level ‘requireAdministrator’ Read More »
Connect Azure SQL from Data Factory using Managed Identity
Azure Data Factory is a Microsoft cloud ETL service for serverless data integrations and orchestrations. It supports a lot of source and target connectors including Azure SQL database. I will describe how to connect to Azure SQL from data factory using Managed Identity.
Connect Azure SQL from Data Factory using Managed Identity Read More »
Databricks Certified Data Engineer Associate
In this post, We have documented how to conquer the Databricks Certified Data Engineer Associate certification in this article. Databricks has introduced the Data Engineering Associate exam which consists of 45 multiple-choice questions. The time slot allocated is 1.30 hr. The passing score is 32 which is 70%. High-level topics with their weightage in the exam are:
Databricks Certified Data Engineer Associate Read More »
Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID Azure SQL Connection
Error AADSTS900021: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID Azure SQL Connection. Cause SQL Server Management Studio can establish the connection to the SQL Server database using Azure Active Directory – Universal with MFA. This is because the Azure Active Directory user trying to log in to
Print Kafka Topic Messages using KSQL
Confluent Platform is a full-scale data streaming managed cloud service that enables us to access, store, and manage data as a continuous, real-time stream. This quick article describes how to Print Kafka topic messages in Confluent.
Print Kafka Topic Messages using KSQL Read More »