While we always recommend to develop the habits of writing clean and well formatted code as part of best programming practices but if there have
Category: powerbi
Did You Know These Amazing Facts About Power BI Paginated Reports
I have been dealing with Power BI for several months now and this term (Paginated Reports) has crossed my eyes multiple times. So, finally, I
Our First Implementation of Small Multiples in Power BI
Since by the day, Microsoft announced small multiples for Power BI this month, we were waiting to get some time, read about this, explore this
Power BI API Limitations
While working on some API stuff today with Power BI, just came across these limitations so thought to share it right away – 75 max
Connecting Power BI Service Dataset in SSMS Using XMLA Endpoint
In the previous post we saw how to connect Power BI Desktop dataset in SQL Server Management Studio (SSMS). Today, we will look at the
Power BI Premium Per User (PPU) – All You Need to Know
Last month Microsoft introduced Per User Premium capabilities for Power BI. Let’s see the highlights of it – Currently this is in Preview i.e. there
How to Connect Power BI Dataset in SSMS
Did it ever come to your thoughts if it could be possible to connect Power BI data in PBIX file and query in SQL Server
How to Check if Power BI Report is in Import Mode or Direct Query Mode
You have got a Power BI report and wondering if it is designed to work in Import mode or using direct query method. Let’s see
All You Need to Know About Power BI Premium
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.
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
