I am having a 7 + years of experience in microsoft technologies including Asp .NET, C# Power BI, SQL Server, SSRS, SSIS, Azure Fundamentals, & Python.
The Row Count transformation counts rows as they pass through a data flow and stores the final count in a variable. Row Count Transformation does not… Read More »Row Count transformation in SSIS
137 total views, 3 views today
Sometimes we close the SSIS toolbox window by mistake, or may be due to some reason it is not showing then you can open the… Read More »SSIS Toolbox is not visible in SSDT
68 total views, 8 views today
Copy Column Transformation in SSIS allow us to create a duplicate columns means it takes an input column and creates a duplicate of it with a… Read More »Copy Column Transformation in SSIS
131 total views, 6 views today
When data is loaded into Power BI model, most of the time Power BI automatically detect the data type of columns. Some times Power BI… Read More »Change column data type in Power BI
94 total views, 3 views today
Microsoft Power BI team has released a December 2021 update. In this update they have added new features and one of the most excited feature… Read More »Add Saprkline to matrix in Power BI
337 total views, 2 views today
To find the highest salary of employee in each department, first we will create a sample tables named EmployeeDetails and Department as shown below. CREATE… Read More »How to get top salary of each department
340 total views, 5 views today
Microsoft Power BI team has recently released November updates such as page and bookmark navigators, new format pane preview feature, sort legend, new text box… Read More »Power BI November 2021 update
267 total views, 1 views today
HTML Color picker, you can search colors either by color name or color hexacode 321 total views, 2 views today
321 total views, 2 views today
In this article you will see how to change the background color for specific rows in a matrix based on values in column. Here, we… Read More »Change matrix background color based on value
305 total views, 8 views today
There are multiple ways to get the size of table in SQL Server. Lets take a look on them one by one. Using sp_spaceused system… Read More »How to get the size of table in SQL
434 total views, 6 views today
Sometimes you need to insert same row multiple times in a table. There are many ways to do that but here we will see one… Read More »Insert same rows multiple times in table
700 total views, 12 views today
A conditional column is a column that is generated based on a condition imposed on an existing column in data model. In general, conditional column… Read More »Conditional Column in Power BI
445 total views, 3 views today
Power BI Custom column adds a new column in data model based on the existing columns in data model. You can create a custom column… Read More »Custom column in Power BI
611 total views, 5 views today
Assume that, you have two tables and you are asked to find out the columns which exists in both table with same name or column… Read More »How to compare column names in two tables in SQL
1,364 total views, 20 views today
You may have faced a situation where you are asked to find values in a column with leading or trailing spaces or remove the leading… Read More »How to find leading and trailing spaces in SQL Server ?
520 total views, 3 views today
Showing a last refresh date and time in Power BI report let you know how fresh your report data is as sometimes report viewer can… Read More »How to show last refresh date in Power BI
559 total views, 4 views today
How to search for string within xml column in SQL table? As you can see here we have a sample table having categories and products… Read More »Search string in xml
375 total views
You may have faced a refresh error when a column name is changed in data source, it happens in such scenario when you have renamed… Read More »Refresh error from changing column names in data source
953 total views, 10 views today
Sometimes, you need to show range of numbers or may be asked to generate a range of numbers between two numbers in SQL Server. Well,… Read More »Generate a range of numbers between two numbers in SQL Server
1,319 total views, 16 views today
Documenting DAX formulas is always a good practice as it saves a lot of time in various scenario such as when your PBI report having… Read More »Export Measures and Calculated columns
2,154 total views, 12 views today