Power BI November 2021 update
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
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
HTML Color picker
HTML Color picker, you can search colors either by color name or color hexacode 
Change matrix background color based on value
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
How to get the size of table in SQL
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
Insert same rows multiple times in table
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
Conditional Column in Power BI
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
Custom column in Power BI
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
How to compare column names in two tables in SQL
In this article you will see how to compare column names in two table. Assume that, you have two tables and you are asked to… Read More »How to compare column names in two tables in SQL
How to find leading and trailing spaces in SQL Server ?
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 ?
How to show last refresh date in Power BI
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
Search string in xml
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
Refresh error from changing column names in data source
You might have faced a refresh error when a column name gets changed in data source, it happens when column name gets changed in data… Read More »Refresh error from changing column names in data source
Generate a range of numbers between two numbers in SQL Server
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
Export Measures and Calculated columns
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
Formatting DAX
Formatting a DAX is good practice as it makes your DAX code well defined and readable. If you have written a DAX code which is… Read More »Formatting DAX
Lost update problem in concurrent transations
A lost update problem occurs in concurrent transactions, when two transactions try to read and update the same column on the same row within a… Read More »Lost update problem in concurrent transations
SQL Return
SQL Return is a control-of-flow language keyword which is used to exit unconditionally from a query or stored procedure. It can be used at any… Read More »SQL Return
Aggregate Transformation Basic Mode in SSIS
The Aggregate transformation applies aggregate operations such as maximum, minimum, average, sum, and count to column values and copies the results to the transformation output.… Read More »Aggregate Transformation Basic Mode in SSIS
Send Multiple files to FTP Server in SSIS
This article demonstrate how to send multiple files from local system folder to FTP Server. If you want to send only single file from your… Read More »Send Multiple files to FTP Server in SSIS
Send file to FTP Server in SSIS
This article demonstrate how to send, or upload file from local system to FTP Server. SSIS allows you to use FTP task which helps you… Read More »Send file to FTP Server in SSIS