Cross-report Drillthrough in Power BI
Patrick leBlanc shows the magic of getting cross-report drillthrough working in Power BI.
2019-05-03
PowerPivot/PowerView/PowerQuery/PowerBI
Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified
In this article, you will learn about one of the most important properties of a relationship called Cardinality.
2019-05-02
Taking Buttons in Power BI Desktop to the Next Level
Amanda Cofsky joins us to show how you can use buttons, in Power BI Desktop, to take your reports to the next level. Blank buttons can really make your...
2019-04-26
Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures
One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can...
2019-04-25
Improve Power BI Report performance by using the filter pane
If you are using slicers in your Power BI report, moving them off to the filter pane could improve performance. Patrick shows you what this could look like based...
2019-04-24
Power BI Streaming Datasets for More Than IoT
Power BI real-time streaming is the perfect solution for IoT. Whether processing data through Azure Stream Analytics, the PubNub data stream network, or a custom Internet of Things solution,...
2019-04-24
Power BI Paginated, DAX, Power Query and more… (April 22, 2019)
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup134 2 Minute Tuesday: https://guyinacu.be/databrickserror Patrick's tech video: https://guyinacu.be/modelview Adam's tech video: https://guyinacu.be/powerbigetdata Sources DAX 101: Summing...
2019-04-22
Export data from Power Query to Local Machine or SQL Server using R scripts
There is always a discussion on how to store back the data from Power BI to local computer or SQL Server Databases, in this short blog, I will show...
2019-04-22
Power Query Memory Usage, Dataflow Container Size And Refresh Performance
When Power BI dataflows were officially released a few weeks ago there was a new setting for Premium capacities mentioned briefly in the announcement blog post: Container Size. The...
2019-04-21
The new Power BI App Workspace experience
The new Power BI App Workspace experience GA'd in April of 2019. Adam takes you through what the new Power BI App Workspace is all about and what is...
2019-04-11
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
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