Widgets provide a way to parameterize notebooks in Databricks. If you need to call the same process for different values, you can create widgets to allow you to pass...
2023-10-13 (first published: 2023-09-28)
285 reads
I have a client who was upgrading some servers from pre-2022 versions of SQL Server to SQL Server 2022 CU7. They had some multidimensional SSAS cubes that were to...
2023-09-13 (first published: 2023-08-18)
227 reads
This week, I was working with a client who requested I use the Segoe UI font in their Power BI report. The report contained a mix of core visuals...
2023-09-06 (first published: 2023-08-17)
103 reads
If you are using Power BI to connect to a PaaS resource on a virtual network in Azure (including private endpoints), you need a data gateway. While you can...
2023-08-21 (first published: 2023-08-01)
665 reads
I recently created a treemap in Power BI for a Workout Wednesday challenge. Originally, I had set out to make a different treemap, but I ran into some limitations...
2023-08-07 (first published: 2023-07-14)
188 reads
One of the nice things about the Microsoft Connector for Oracle is that it doesn’t require installation of an Oracle client. But because of this, you may not have...
2023-06-21 (first published: 2023-06-03)
293 reads
The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from...
2023-05-01 (first published: 2023-04-21)
716 reads
Did you know that you can change the browser used by SQL Server Management Studio to authenticate using Azure Active Directory to a SQL database in Azure? I had...
2023-04-12 (first published: 2023-03-28)
486 reads
In February 2023, Microsoft released some new Power BI themes that are more accessible than the other themes available by default. The blog post mentions the prevalence of color...
2023-02-25 (first published: 2023-02-24)
68 reads
I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power...
2023-02-06 (first published: 2023-01-24)
343 reads