In this blog, we will see how we can convert rows into comma-separated values in single rows using Power BI. Step 1: Import your table and go to transform data and remove empty or null rows if any.

Hello, friends in this blog we will see how to trigger the azure data factory pipeline using a logic app. Step 1: Create the Azure Data Factory pipeline for your integration. Step 2: Create a logic app of your preference, for this blog I am creating an HTTP trigger logic…

Hello everyone, in this blog we will see how we can schedule a job for our notebook to run at specific intervals. Step 1: Launch your databricks workspace and go to Jobs. Step 2: Click on create jobs you will find the following window.

Hello, in this blog we will see how we can add rows to the power bi dataset for a given date range. For example, if you have a dataset that has start and end dates and you want rows for each date between this range then this blog will help…

Hello everyone in this blog we will see how we can query only recently modified data from dynamics CRM for our integration using Azure function in C#. Step 1: Open visual studio and create azure function, you can create an HTTP triggered function if you want it to run on a…

Hello, everyone in this blog we will see how we can use the azure key vault to store our sensitive information in a secured way and then use that information in Azure data bricks. Step 1: First of all, we need a databricks workspace so go ahead and create a databricks…

In this blog we will see how you can host your static website on azure, the process is a bit long but once you do it one step at a time it is almost free. Step 1: Develop your static website keeping index.html as your home page. Make proper folder structure…

Hello Friends, have you ever thought of tracking the changes that happen to your data in SQL? This can be achieved with different techniques one of them is with SQL triggers but the method that I am going to demonstrate is a bit simple and does not involve SQL triggers…

These days getting a vaccination slot is such a pain. every time we see slots not available. In this blog, I will help you to solve this problem using Azure Logic Apps. The logic app sends me an email every time a slot is available in my area, all I…