Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-12-09 (first published: 2024-11-27)
337 reads
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse with a metadata-driven, pattern-based approach. One of the benefits I mentioned is that it’s easy...
2024-10-28 (first published: 2024-10-14)
251 reads
A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-10-21 (first published: 2024-09-30)
222 reads
I had a couple of clients who were moving content from development catalogs to production catalogs for the first time. They wanted to copy the schema and data from...
2024-09-25
17 reads
One of the new features in the August Power BI Desktop release is the updated legends that are styled to more accurately reflect the per-series formatting on the visual....
2024-09-16 (first published: 2024-08-26)
139 reads
External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas before, we might have needed an intermediate technology to make a REST call to an...
2024-07-29 (first published: 2024-07-23)
468 reads
Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with...
2024-07-08 (first published: 2024-06-21)
194 reads
This comic was retweeted into my timeline on Twitter (I refuse to call it X). Here’s the dialog from the comic, for those that don’t want to click through...
2024-06-10 (first published: 2024-05-20)
333 reads
Have you ever wanted to filter a visual by selecting a range of values for a measure? You may have found that you cannot populate a slicer with a...
2024-05-13 (first published: 2024-05-01)
282 reads
I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks...
2024-04-10 (first published: 2024-04-02)
198 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...