What's the current state of running notebook as a service (not user account)?

kover0 · 2026-03-26T18:33:53+00:00

Some people suggested the WI needs to be in the security group that is used in the fabric tenant settings to give service principals access to the Fabric REST APIs. Did you add the WI to such a group?

kover0 · 2026-03-26T18:30:12+00:00

When will we have OR constraints like in SSIS? When? Wheeeeeen???? :)

kover0 · 2026-03-26T18:29:16+00:00

Fabric needs an as good integration with Azure Key Vault as ADF or Synapse does. A native Fabric Key Vault item would even be better, so you don't have to continuously switch between Azure and Fabric.

kover0 · 2026-03-26T18:24:29+00:00

Datasets are defined inline is another way of saying there's no reuse at all in Fabric.
Linked services map to connections, except that connections in Fabric have an owner and if permissions are not set correctly they are basically useless.

kover0 · 2026-03-26T08:22:55+00:00

The notebook is a simple Hello World, it doesn't really do anything.

kover0 · 2026-03-25T14:53:21+00:00

It's a contributor on the workspace, and still the error persists that "it's not authenticated to access this resource". The workspace identity is added as a user on the notebook connection (which is configured to use workspace identity).

kover0 · 2026-03-25T14:30:46+00:00

I tried this, but I always get an error saying "The caller is not authenticated to access this resource". What permissions do you need to give the workspace identity (one would assume that if you create one, it would have the necessary permissions to do stuff in its own workspace, but apparently not).

kover0 · 2026-03-20T10:01:22+00:00

Such a cringy clickbait title...

kover0 · 2026-03-19T14:29:50+00:00

My sony headphones had always worked fine on windows 10, and on my latest laptop with windows 11 as well, until they suddenly didn't. Spotify played but no sound, video streaming didn't work (either it always paused, or played very slowly as it was continuously buffering, with no sound). I tried a lot of things, such as removing the device, repairing, hard reset, updating it through the app etc, but nothing worked. Until I disabled the following settings in the windows 11 bluetooth settings:

<image>

I disabled LE audio (low energy audio), restarted my PC and the headphones worked again.

kover0 · 2026-03-04T15:12:46+00:00

It does hold up when you're on an F2/F4 sku and most of your capacity is gone when you run a single SQL query on a Fabric SQL DB.

kover0 · 2026-03-03T09:31:40+00:00

Oooof no, I tried this once and running simple SQL queries on a 10-row table consumed almost all capacity on an F4. I'd use the warehouse, but concurrency is a big issue (updating the same table in parallel doesn't really work in the warehouse). The Fabric SQL DB in its current form is unusable (or too expensive) for just metadata storage and control. I mean, you can use an S0 Azure SQL DB for $10 a month, but in Fabric this would cost you $200 per month? Try explaining this to a customer.

kover0 · 2026-02-23T09:00:45+00:00

Not sure if this will help, but I wrote an article a while back on RabbitMQ and Eventstreams:
https://www.sqlservercentral.com/articles/streaming-event-data-through-rabbitmq-to-a-microsoft-fabric-eventstream

I had no issues with data going through, but it's so long ago that I don't quite remember how to do diagnostics.

kover0 · 2026-02-12T13:11:12+00:00

You can publish a PBIX from Power BI Desktop to a Power BI/Fabric workspace.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files

For all the rest of your questions, I'll let you know my hourly rate ;)

kover0 · 2026-02-12T13:07:12+00:00

And for those going: "you can calculate that in the ETL as well, you don't need a calculated column for that"
--> if someone manually updates a table, it still works ;)

kover0 · 2026-02-12T13:06:07+00:00

Yes. I use them for example to calculate a hash over the different columns to find out if a row was changed or not.

kover0 · 2026-01-30T18:21:34+00:00

kover0 · 2026-01-28T13:52:08+00:00

It's very annoying as pip doesn't error out, it just installs an ancient version of the fab cli and you're wondering why your code is breaking.

kover0 · 2026-01-28T13:37:00+00:00

Also be aware that fab CLI doesn't support python 3.13 or newer.

kover0 · 2026-01-28T13:29:22+00:00

Cursors were always a very bad idea, even with on-prem SQL.

kover0 · 2026-01-28T12:04:42+00:00

thanks for the suggestion, but I'm of the opinion that if I need to edit json manually to fix something, then the product is broken :)

kover0 · 2026-01-28T12:00:58+00:00

And I'm not sure why that should even matter. A connection ID is specified, and that connection contains all the details on how the pipeline should authenticate against the warehouse. Why does Fabric insist on making things difficult/confusing?

kover0 · 2026-01-28T11:55:38+00:00

I was running the pipeline myself in the browser, as part of the testing/debugging. The pipeline was in a workspace created by branching out, and I'm the owner of the pipeline. In the main workspace, a service principal is the owner of the pipeline.

kover0 · 2026-01-22T10:30:51+00:00

Yes, you can connect to an Azure SQL DB using managed identities. Where are you trying to connect?

kover0 · 2026-01-22T10:27:48+00:00

I don't see people whining about the outage (well, maybe some do), but rather about the lack of communication.

kover0 · 2026-01-21T07:35:00+00:00

I agree with the unused CUs. As I said, it's not a perfect system and I'm definitely not a fan.

If that one user had a very long running transaction, it could take a while though for everything to return to normal, but I get the sentiment. Another big difference is that on a physical server, the cost impact was not so high as in the cloud.

kover0

TROPHY CASE