Common Data Transformations in Power Query
In this article we walk through an example of using Power Query to transform source data that can be used in a Power BI report.
2021-04-21
Power BI
Power BI Anomaly Detection
One of the problems with data analysis is the potential for anomalies that can skew results. In this article we look at a Power BI feature to detect anomalies and outliers in the data.
2021-04-09
Power BI Smart Narrative
A new feature in Power BI is the Smart Narrative that allows you to add a textual narrative to your reports to help provide additional information to the user.
2021-03-26
Power BI Small Multiples Visual Example
Power BI has a new feature which is the Power BI Small Multiples visual. In this article we cover how to enable this feature and also walk through an example of how to use this in a Power BI report.
2021-03-05
Create Azure DevOps Analytics Visuals with Power BI OData Queries
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
2021-02-05
Power BI Theme Generator New Methods and Customizations
New methods and usage for themes were recently introduced for Power BI and in this article we cover how you can use these and customize them for Power BI.
2021-01-28
Power Query or SQL Server? Which, when and why
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
17,122 reads
Power BI Merge Queries and Append Queries
In this tip we will cover how to use merge and append in Power BI to add additional data to a dataset that can then be used in reports and visuals
2021-01-22
Create Azure DevOps Analytics Visuals with Power BI OData Queries
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
2021-01-21
Dynamic Power BI Slicer Using DAX Logic
Learn how to create dynamic data slicers in Power BI with this step by step example to show how this can be done.
2021-01-14
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers