Power BI, Power Platform, Data Platform
Blogging about Power BI, Power Platform and other things I find interesting.
Tuesday, January 10, 2023
Power BI 2022 In Review: My Favourite Features
Friday, December 30, 2022
Closing out on 2022

Blogging
Speaking
I've had some great speaking gigs this year, like a virtual presence at SQLBits, The Dutch Power BI User Day (Deep Dive as well as the free Saturday), DataGrillen, and (both virtual) New Zealand Business Applications Summit and the Pakistan Power Platform Bootcamp.
MVP
Learning goals
Are you still interested in taking this exam? Have a look at my overview post.
I didn't do much reading, in books that is. I've read numerous blog posts, but not really any books. Let's up that game in 2023 and put in effort to do more reading.
I do like listening to podcasts, ranging from running (Susy Q&A, Klaas en Koen lopen weg) to tech (Knee-Deep in Tech, Kasper on BI, Explicit Measures). I like to listen to them during my morning or lunch walks and sometimes during running also.
Powerdobs
However, I missed the point of being with my hands on the buttons of Power BI a bit, so I couldn't resist taking the chance to join this family of Power BI enthusiasts at Powerdobs. And it truely feels like a little family here! π
Sports/health
I did a half marathon today! Not the wanted PR, but still satisfied I completed it! #runhappy pic.twitter.com/rJ2sEsnVIF
— Nicky van Vroenhoven (@NickyvV) October 9, 2022
I've also been doing some cold showers and Wim Hof (a.k.a. the Iceman) breathing exercises once in a while the last year. But in the beginning of October I've had the pleasure of attending a Wim Hof (half day) workshop, on mindset, breathing and cold. So I took an ice bath! π
After that day, I've been consistently doing a cold shower every morning now! It feels amazing going through that stress and adrenaline rush in the morning, and feeling relaxed after a few seconds of focussing on my breathing.
I just have to get the breathing exercises incorporated more into my daily routine also.
That's all for this year. I whish everyone the best New Year's Eve and a great start of 2023!
Nicky. Out.
Monday, December 19, 2022
SSMS Error when refreshing a Power BI Table: Paramter name already exists
2 weeks ago I talked about A No-Code Method to Refresh One Table From a Power BI Dataset in the Service. I recently ran into an error using this method, so I thought it was worth sharing this error, and the solution π, with you.
TL;DR
Problem
"With some tools it might be necessary to also provide the Initial Catalog (the dataset to connect to in your workspace). The datasets in your workspace will eventually show as databases under your AS-server:"
- Note that the message itself also has a typo in it (paramter π).
- It happens to every table in every dataset (I tried so far) in this workspace. I tried another workspace and that refreshed fine from the UI.
- A colleague is getting the same error message in the UI for this particular workspace.
- Looking at the error I checked if there are params called name in the datasets, but there aren't.
- It's a test workspace in a deployment pipeline.
Solution
- Don't use the Initial Catalog option in combination with SSMS, leave it at <default>
- Or, if for any reason you need the above option selected, install SSMS 19 Preview 4
- This preview version is a side-by-side installation, so it installs next to SSMS 18.x