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
Category: Power BI
Did You Know…Power BI Scheduled Refreshes are Paused Automatically if…
This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept
Measure Your Productivity in Power BI with Zero Efforts and Instantly
Last week Microsoft released Teams activity reports in Power BI that allows you to analyze how much time you have been spending on meetings, how
Power BI Data Flows Refresh History – Chrome or Firefox…Does it Really Matter?
An interesting observation was made today. I had to check the refresh history of one of our data flows so casually logged into Power BI
Connecting Power BI to Azure SQL Read Scale Out REPLICA
You have read scale out replicas available to your Azure SQL Database subscription? Then, you must consider to connect your Power BI desktop to offload
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
It has been around three months now (as of March 03, 2021) since Microsoft introduced Per User Premium capabilities for Power BI. Let’s see the
How to Connect Power BI Dataset in SSMS
Had 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