Latest Blog for Microsoft Dynamic 365 Solutions | CloudFronts

How to Hide the filters panel in Microsoft Power BI report

Posted On April 27, 2020 by Sandip Patel Posted in

In this blog we will learn how to hide the filter panel in Microsoft Power BI report. Once you publish the Power BI report in Power BI service, filter panel is useless for the end user. In order to hide the filter pane, you have to follow the below steps. Step 1: Open your report … Continue reading How to Hide the filters panel in Microsoft Power BI report

Share Story :

Microsoft Power BI – Joining contents of two tables into one table using Append Power Query

In this blog we will learn how to append two or more table into new table or existing table. The Append Queries in Microsoft Power BI is an equivalent of UNION ALL in SQL. Consider two sample customer table; one for CustomerOne: And Customertwo: Open Microsoft Power BI for Desktop > Get Data > Excel … Continue reading Microsoft Power BI – Joining contents of two tables into one table using Append Power Query

Share Story :

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 :

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