There has been so much about Power BI licensing that it always gets confusing when someone starts exploring and finding the best option for them.
Category: powerbi
Refreshing Power BI Desktop Previews Faster
There are two options to refresh the previews in Power Query – Refresh Preview and Refresh All. Refresh Preview updates the sample data for current
How to Check Power BI Tenant
If you are trying to locate the region your tenant is in i.e. the place where Power BI will be storing your data in, this
Use COUNTROWS instead of COUNT
Both COUNT() and COUNTROWS() functions accepts single parameter. The difference lies in the fact that COUNT() operates over a column whereas COUNTROWS() asks for the
Best Practice to Deal with BLANK in Power BI
Measure definitions where BLANKs are converted into some default or alternate values are generally considered as poor design because they are not efficient. When measures
Count(), CountA(), CountRows() and CountX() Functions
Both Count() and CountA() functions counts non-blank values but works with different data types. Count() = works with Numbers, Dates and String data types only
Calendar vs. CalendarAuto
Calendar() and CalendarAuto(), both functions help you to create a base table for date dimension. They give you a contiguous set of dates which is
Import Data vs. DirectQuery vs. Live Connection
Import Data Imports whole dataset into Memory. This memory will be the memory of machine hosting your Power BI report. With the span of time
An Introduction to DAX
DAX stands for Data Analytical Expressions. This is a language in itself that can be leveraged to do all analytical calculations, be it regular aggregations
Power BI Pricing Model
There always have been some confusion around what all different Power BI licensing options means. In this post, we will try to clear those doubts.
