Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
8,711 reads
Power BI
Fetch Web Data in Power BI
Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this article, I'm going to demonstrate how to connect to a web application from Power […]
2020-03-17
5,532 reads
Using the RANKX function in Power BI
Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]
2020-03-12
20,379 reads
Power BI Advanced Q&A
What advanced features are available in the Power BI Q&A functionality? Also, how does the new Q&A visual work?
2020-01-31
Month-over-Month calculation using DAX in Power BI
Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing, so the same amount of time has passed in the two […]
2020-01-27
78,331 reads
Synchronously Refreshing a Power BI Dataset using Azure Logic Apps
In this tip we will implement a polling mechanism to verify if the Power BI dataset has refreshed successfully.
2019-12-25
Azure Text Analytics and Power BI
In this tip we look at how to analyze textual data to gain insight from freeform text using Azure Text Analytics and Power BI.
2019-12-13
Power BI Filter Pane
Data Filtering | Configurations - In this tip we look at a new feature in Power BI that allows users to filter data in Power BI reports using the new Filter Pane.
2019-11-29
Merging tables in Power BI dataflows with PRO subscription
Power BI dataflows is a powerful self-service ETL tool. However, some features demand the use of Power BI Premium, way more expensive than the PRO version and sometimes inaccessible. In this latest blog post Dennes Torres explores the subject.
2019-11-18
Power BI Workbooks
Power BI Workbooks | Step by Step - In this tip we look at how to work with Power BI workbooks and in the previous tip we looked at working with Power BI datasets.
2019-11-14
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers