Aggregations in Power BI
Aggregations have been introduced in 2018 in Power BI, as an optimization technique to manage large tables. By providing pre-aggregated tables, you can highly improve the performance of a...
2019-04-15
Power BI
Power BI Helper April 2019 Edition
Reza Rad announces an update to Power BI Helper: Previously you could use Power BI Helper to connect to a model in Power BI Desktop and analyze that model,...
2019-04-15
Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1
Previously, I have written about using Power Query transformations and functions to create an Exception report for Power BI. However, the method I mentioned there, was only doing the...
2019-04-14
What Is the XMLA Endpoint for Power BI and Why Should I Care?
The news about XMLA endpoint connectivity to Power BI datasets is now all around the internet after the public preview announcement of that last week. However, I realized that...
2019-04-08
Create Power BI Connection to Azure SQL Database
Learn how to use Power BI to retrieve data from an Azure SQL Database.
2019-03-15
2,461 reads
Getting Started with Power BI - Part 1
In this tip we will show how Power BI works and how to create a simple report from scratch and the options available for creating reports.
2019-03-01
5,579 reads
Visualise SQL Server IO Stats
Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning.
2020-08-07 (first published: 2018-12-18)
6,122 reads
Power BI Introduction: Visualizing SQL Server Audit Data — Part 9
SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.
2018-12-17
3,047 reads
Creating Calculated Columns Using DAX
In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX.
2018-11-22
2,396 reads
Power BI Introduction: Publishing Reports to the Power BI Service — Part 8
Power BI Desktop is typically used to create reports that will eventually be published to Power BI Services where dashboards can be built. Robert Sheldon demonstrates how to publish reports from Power BI Desktop to the Power BI Service. Once published, the visualizations can be filtered, drilled into, or pinned to a dashboard.
2018-10-08
3,198 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Putting the Player with the Number
Comments posted to this topic are about the item Putting the Player with the...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers