Dinesh's Blog :::: Being Compiled ::::

We generally expect a proper row terminator with files loaded using bcp  and with all accurately defined switches, data should be loaded w...

This is not something released this month but March 2017. These new capabilities of Power BI Slicer is available but many do not use it be...

Normalization is a process of identifying the optimal grouping (relations at the end) for attributes that satisfies data requirements in a...

Microsoft Power BI supports adding parameters for queries and use them with various areas. However, since it has some limitations and cann...

I wrote a post on Relational Algebra that discusses most of operations related to it. This is the continuation of it and this explains Jo...

Power BI Desktop allows us to import data from files such as CSV and Excel . Once imported, it automatically creates a Model  that can be ...

Power BI allows us to add shapes like rectangle or oval  for marking specific area, showing covered visuals as they are related and operat...

How do you name columns returned from your created view? Generally, you do not need to explicitly name them as the names of view-columns  ...

Everyone has either used or created  views for getting or creating a dynamic result using one or multiple tables. And everyone knows the u...

Creating a report with stunning, meaningful and appropriate visuals is the key for delivering the information quickly, hence special consi...

Let's talk about another Interview Question  related to SQL Server development. This is about one of the aggregate functions that is A...

Have you experienced that Power BI just connects with your SQL Server without requesting your login credentials? Or you might need to conn...