Category: ETL

Loadtesting Fabric part 2, bringing Pain to Powerbi

In my previous blog on Fabric and loadtesting, I ended with not really knowing how PowerBI would respond to all these rows. After creating and presenting a session on this subject, it's time to dig into this part of Fabric as well. There were questions and I made promises. So here goes! This blog will … Continue reading Loadtesting Fabric part 2, bringing Pain to Powerbi →

Microsoft Fabric GA, and now?

Last week the big announcement came at Microsoft Ignite, Fabric is GA. Very cool, a lot of noise again for this shiny toolbox, but do we need to abandon everything and focus solely on the new toys? Before I'll answer that question, let's look at a few moving parts of Fabric. Integration The most important … Continue reading Microsoft Fabric GA, and now? →

Why won’t you go parallel, part 2

In my previous blogpost (Click here to read) I wrote about a query that just wouldn't go parallel. This sparked some discussion and interest from a few people who were very kind and helpful with their suggestions and even deep dives into the query plans, execution statistics etc. To make one thing very clear, this … Continue reading Why won’t you go parallel, part 2 →

Microsoft Fabric, capacity usage and a design

This monday, I was lucky enough to attend the Fabric level 300 precon at dataMindsConnect. If you ever have the chance to go there, do it! It's very well organised, the sessions are amazing and so are all the people there. But that's not what this blog is about; today a Twitter thread started on … Continue reading Microsoft Fabric, capacity usage and a design →

Microsoft Fabric: setting your spark compute pool size

This next blog won't be a long one and will probably serve most as a reminder for myself where to find the settings for the Spark compute pool. When you create a workspace, you get the default starter pool and it has taken me way longer than I care to admit to find where to … Continue reading Microsoft Fabric: setting your spark compute pool size →

Notebook exit code 137. Cause and solution

Yes, I've been at it again with Microsoft Fabric, and as I'm trying to find the limits of this new cool toy, the limits sometimes get angry with me and throw an error. Most of the time this error is caused by me and I can usually figure out what's happening, but not always. Exit … Continue reading Notebook exit code 137. Cause and solution →

Getting on-premises data into Microsoft Fabric using the data gateway

In a blog from a few weeks ago, I wrote about getting data from your on-prem SQL Server into Fabric. At the time, the only option for a copy dataflow was using a direct connection over the internet. It still is, but now you can also use the PowerBI Data Gateway to get data from … Continue reading Getting on-premises data into Microsoft Fabric using the data gateway →

Microsoft Fabric: shortcuts and table clones

A few days ago, I heard the term table clone for the first time, it's preview release date was to be confirmed and I had no idea what it was about. Two days later, a video emerged where the table clone was explained on a high level. At that point, I started to wonder what … Continue reading Microsoft Fabric: shortcuts and table clones →

View with a where clause

I was teaching a class and during an interesting discussing an attendee told me that views with a filter took a long time to produce results, even if the result set itself was quite small. I wanted to test this out for myself to see what was happening. I'll take you along this short journey … Continue reading View with a where clause →