Latest Blog for Microsoft Dynamic 365 Solutions | CloudFronts

SQL Server Delete duplicates record from a table

Posted On February 20, 2020 by Sandip Patel Posted in

In this blog we will learn how to delete duplicates records from a table in SQL Server. Let’s create a sample table for the demo. Step 1: Create temporary table called tmpTable as follows DECLARE @tmpTable TABLE(EmpID INT IDENTITY(1, 1), EName VARCHAR(50)) Step 2: Insert some record into the tmpTable table. INSERT INTO @tmpTable(EName) VALUES … Continue reading SQL Server Delete duplicates record from a table

Share Story :

How to get Email notification when Azure Data Factory Pipeline fail

However, it seems there’s no “e-mail activity” in Azure Data Factory. I would like to send an e-mail notification if one of the activities fail. In this blog I am going to explain you how to send an e-mail notification using ADF Web Activity and Azure Logic App. Sending an Email with Logic Apps Logic … Continue reading How to get Email notification when Azure Data Factory Pipeline fail

Share Story :

How to create Date tables in Power BI. Why are they remarkably important in data models?

Posted On February 13, 2020 by Sandip Patel Posted in

In this blog I am going to explain you how to create a Date table in Power BI desktop. A date table is a table that contains one column of DateTime type with unique values. It’s also called CALENDAR table A data model typically contains a date table A date table is designed to slice … Continue reading How to create Date tables in Power BI. Why are they remarkably important in data models?

Share Story :

How to use a Custom URL for your text column in Power BI

Posted On January 13, 2020 by Sandip Patel Posted in

In this blog I am going to explain you how to create a custom URL for your text column in Power BI desktop. You can create hyperlinks in tables and matrix in Power BI desktop. Before jumping to use a new feature in Power BI desktop, I am showing you how we had done previously. … Continue reading How to use a Custom URL for your text column in Power BI

Share Story :

Send an e-mail to any audience when Power BI data alert is triggered

Posted On January 7, 2020 by Sandip Patel Posted in

In this blog I am going to explain you how to send an e-mail to any audience when a Power BI data alert is triggered. Step 1: Create a sample of Power BI report using visuals like gauge, KPI or card title. Step 2: Publish your Power BI report on app.powerbi.com site. Step 3: Pin … Continue reading Send an e-mail to any audience when Power BI data alert is triggered

Share Story :

“What If” Parameter in Power BI

Posted On December 27, 2019 by Sandip Patel Posted in

This blog will explain how to use “What If” Parameter in Power BI desktop. Via What If parameter in Power Bi can easily give you the ability to dynamically transform your data. Using this parameter will allow to demonstrate how your data change under various scenarios. For example, how much revenue would you have if … Continue reading “What If” Parameter in Power BI

Share Story :

Top 20 Best Practices of Power BI

Posted On December 27, 2019 by Sandip Patel Posted in

In today’s business intelligence world, Power BI has become a beloved among many. In this blog, I am going to cover Power BI best practices, that will assistance to you while developing the Power BI report. Company Logo Use the logo in their background. Data Timestamp to show, when it was refreshed last We can … Continue reading Top 20 Best Practices of Power BI

Share Story :

How to create a Gantt Chart or Progress bar inside a Table in SSRS

In this article, we will create a Gantt Chart or Progress bar inside a table in SSRS . In SQL Server Reporting Service does not allow a report programmer to modify a “width” property at run time. The challenging part of this task is how to create a scale and how to create a progress … Continue reading How to create a Gantt Chart or Progress bar inside a Table in SSRS

Share Story :

Embed Secure Power BI report using Python Web Application with Flask in Visual Studio 2015

Posted On October 31, 2019 by Sandip Patel Posted in

In this article, we will embed a Power BI report in a python web application with flask in visual studio 2015. Following are the steps to embed a report. STEPS: Create a new Python Web Project by selecting “Web Project” under Python in Visual Studio 2. If you can’t see this option then first you … Continue reading Embed Secure Power BI report using Python Web Application with Flask in Visual Studio 2015

Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close