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
Power BI
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,111 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
Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6
In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language to import and transform data.
2018-08-20
2,844 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...