Unpivot a matrix with multiple fields on columns in Power Query
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-01-26 (first published: 2023-01-24)
78 reads
Meagan Longoria
Use the output of a Script activity as the items in a ForEach activity in Data Factory
In early 2022, Microsoft released a new activity in Azure Data Factory (ADF) called the Script activity. The Script activity allows you to execute one or more SQL statements...
2023-01-09 (first published: 2022-12-22)
219 reads
Clickable SVG images in Power BI using the HTML Content custom visual
People have done creative things with SVG measures in Power BI, ranging from KPI cards to infographics to fun games. For my latest Workout Wednesday challenge, I used SVG...
2022-12-28 (first published: 2022-12-15)
231 reads
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The type of engagement you choose affects the pace and deliverables of the project, and the...
2022-12-26 (first published: 2022-12-06)
204 reads
Creating a Unity Catalog in Azure Databricks
Unity Catalog in Databricks provides a single place to create and manage data access policies that apply across all workspaces and users in an organization. It also provides a...
2022-12-07 (first published: 2022-11-23)
190 reads
The Reason We Use Only One Git Repo For All Environments of an Azure Data Factory Solution
I’ve seen a few people start Azure Data Factory (ADF) projects assuming that we would have one source control repo per environment, meaning that you would attach a Git...
2022-11-09 (first published: 2022-10-31)
234 reads
Why I tweet about work and personal topics from the same account
Over the last few years, I’ve had a few people ask me why I don’t create two Twitter accounts so I can separate work and personal things. I choose...
2022-10-07 (first published: 2022-09-26)
214 reads
pandas.DataFrame.drop_duplicates and SQL Server unique constraints
I’ve now helped people with this issue a few times, so I thought I should blog it for anyone else that runs into the “mystery”. Here’s the scenario: You...
2022-08-31 (first published: 2022-08-20)
230 reads
Generating Unicode Characters in Power Query
You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I...
2022-07-18 (first published: 2022-06-30)
171 reads
Quality Checks for your Power BI Visuals
For more formal enterprise Power BI development, many people have a checklist to ensure data acquisition and data modeling quality and performance. Fewer people have a checklist for their...
2022-07-15
118 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
How to append data to the previous row
Hi, I have a table that stores event transactions, the sample data see the...
Replacement for char and ascii functions in natively compiled stored procedures
I am trying to create a natively compiled stored procedure where I need to...
Do entry-level cloud positions exist?
Hello friends. I’m new here, so if this is the wrong place for my...
Ask SSC