Power BI is a business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
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
8,976 total views, 5 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
9,602 total views
LOOKUPVALUE function is a Power BI Filter function in DAX, it returns the value for the row that meets all criteria specified by one or… Read More »LOOKUPVALUE function DAX
6,542 total views, 5 views today
Set alerts in the Power BI service to notify you when data on a dashboard changes above or below limits you set. Alerts can only… Read More »Data Alerts in Power BI service
3,479 total views
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data basically a data that is not in… Read More »Install and Configure on-premises data gateway
3,538 total views, 1 views today
OPENINGBALANCEMONTH function is a Power BI time intelligence DAX function which evaluates evaluates the specified expression for the date corresponding to the end of the… Read More »OPENINGBALANCEMONTH Function DAX
4,086 total views
CLOSINGBALANCEMONTH function is a Power BI time intelligence DAX function which evaluates the expression at the last date of the month in the current context.… Read More »CLOSINGBALANCEMONTH function DAX
4,631 total views, 1 views today
Power Query add column from examples feature, allows you to add new columns to data model simply by providing one or more example values for… Read More »Add a columns from examples in Power BI
1,563 total views
The append operation in Power Query creates a single table by adding the contents of one or more tables to another, and aggregates the column… Read More »Append Queries in Power BI
5,312 total views, 6 views today
Power Query provides a feature that is Unpivot columns which allows you to transform columns into attribute-value pairs, where columns become rows. Columns that you… Read More »Unpivot Columns in Power BI
3,319 total views, 2 views today
Power Query provides a FILL operation which allows you to fill up and fill down to replace null values with the last non-empty value in… Read More »Fill values in column in Power BI
5,894 total views, 2 views today
The data profile allows a intuitive ways to clean, transform, and understand data which helps you identifying the nuances of the data such as determining… Read More »Create a Data Profiling report
4,522 total views, 1 views today
The data profiling allows a intuitive ways to clean, transform, and understand data in Power Query Editor, which helps you identifying the nuances of the… Read More »Profile Data in Power BI
3,263 total views, 1 views today
LASTNONBLANK function is a Power BI time intelligence function in DAX which returns the last value in the column filtered by the current context for… Read More »LASTNONBLANK function DAX
5,589 total views, 3 views today
Row-Level security (RLS) is a feature of Power BI that can be used to restrict data access for given users, so the appropriate person can… Read More »Row-Level Security (RLS) in Power BI
7,078 total views, 1 views today
Custom function in Power BI allows you to use a same piece of code repeatedly multiple times. Sometime, you may get a situation where you… Read More »Custom function in Power BI
2,622 total views, 5 views today
This is a performance and usage metrics features that you can use in a workspace. Using these metrics, you can view who is using your… Read More »Monitor usage and performance in workspace
2,725 total views, 1 views today
A Radial Gauge chart has a circular arc and shows a single value that measures progress toward a goal or a Key Performance Indicator (KPI).… Read More »Radial Gauge Chart Power BI
3,324 total views, 1 views today
Performance Analyzer is a tool within Power BI desktop, that allows you assess your report’s performance and identify area of improvement. Using this you can… Read More »Power BI Report Performance Analyzer
3,454 total views
TRUNC function is a Power BI math and trig function in DAX, which truncates a number to an integer by removing the decimal, or fractional… Read More »TRUNC function DAX
4,818 total views, 1 views today