DAX – UNION function
UNION DAX function in Power BI, How to combine two or more Tables in Power BI? Read More
Home » Archives for PowerBIDocs »
PowerBIDocs
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 it. 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 state. Read More
SQL CONVERT() Vs TRY_CONVERT() function
The SQL Convert() or TRY_Convert() both are SQL Conversions Functions and similar to CAST() or TRY_CAST() functions with an additional optional parameter ‘Style’. 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
Power BI – Sync Slicers
Understand Sync slicers Or Synchronized Slicer in Power BI Desktop. Read More
Power BI Custom Theme JSON File
How to Set Custom Color Themes in Microsoft Power BI Desktop to using JSON file? Read More
Power BI Performance Analyzer
How to optimize Power BI Report Performance with Performance Analyzer? Read More
SQL – Full DB Backup Script
Database backup is very important for any organization, this post explains how you can take SQL backup through SQL script. Read More