SQL Server Dirty Read Concurrency Problem
SQL Server Dirty Read is a part of Concurrency problem, it occurs when one transaction is allowed to read the uncommitted data. Read More
Home » Archives for PowerBIDocs »
PowerBIDocs
Power BI – Edit Interactions
What is Edit interactions in Power BI? Turn off visual default interactions to each others. Read More
DAX – ALLEXCEPT function
ALLEXCEPT DAX function in Power BI | How to use ALLEXCEPT Functions in Power BI? Read More
How to make DAX formula easy to read?
How to use DAX formatter to convert your long lines DAX formula in readable format? Read More
DAX – UNION function
UNION DAX function in Power BI, How to combine two or more Tables in Power BI? Read More
DAX – DATATABLE Function
Datatable is a DAX function, using this function you can create Static Dataset/ Table in Power BI, that cannot be refreshed but you can modify Read More
Power BI – Page Navigation with Bookmarks & Buttons
Bookmarks is a very cool feature in Power Bi, using this you can capture currently configured view of a report page including slicers & visuals Read More
SQL CAST() vs TRY_CAST() function
using this function you can convert an expression from one data type to another. Read More
SQL Server Keys
Types of SQL Server Keys – Primary Key, Foreign Key, Alternate Key, Super Key & Unique Key. Read More
SQL – ALTER Table Statement
The ALTER TABLE statement is used to add, modify or drop columns in an existing table. Read More
Create a Hierarchy in Power BI
What is Hierarchy in Power BI? Create and manage hierarchies in Power BI. Read More
SQL Server Configuration Functions
Some useful SQL Server configuration functions: @@SERVERNAME, @@VERSION, @@SPID & @@LANGUAGE Read More
SQL Server Commands
Types of SQL Server commands- DDL, DML, DCL, TCL, DQL, Or list of SQL Server commands. Read More
SQL Server REPLICATE Function
SQL Replicate is a String function, it is used to repeat the existing string for a specified number of times. Read More
SQL Server @@IDENTITY, SCOPE_IDENTITY() & IDENT_CURRENT
A SQL Server IDENTITY column is used to generate key values automatically based on a provided seed and increment value. Read More
SQL Query Optimization
What is SQL Server Query optimization? Improving Query Performance in SQL Server. Read More
Power BI – Get Web Page Data into Power BI
How to Get Data From Web Page Into Power BI? or How to use a Web data source in Power BI Desktop? Read More
Power BI – Stacked Column Chart
Power BI – Create a Stacked Column Chart | Stacked Column Chart in Power BI. Read More
Power BI – Stacked Bar Chart
How to Create a Stacked Bar Chart in Power BI Desktop. Power BI inbuilt visual Stacked Bar chart. Read More