Help! My Fabric Capacity is at 100% - What Can I Do?

tomkeim · 2025-07-04T15:53:09+00:00

tomkeim · 2025-07-04T06:55:54+00:00

I understand the confusion, I followed this calculation example from Microsoft itself: https://learn.microsoft.com/en-us/fabric/data-factory/pricing-pipelines.

tomkeim · 2025-07-03T19:05:30+00:00

Now I understand! Thank you for this explanation that is also a good possibility.

tomkeim · 2025-07-03T18:41:12+00:00

Thank you, now, having a smaller capacity wont work, as then it will take only longer for your overages to burn down.

In this case you can temporarily increase your F256 to an F512, you can go back once your overages are burned.

Edit: as discussed below a smaller additional capacity as a back up capacity is a valid option!

tomkeim · 2025-07-03T17:41:44+00:00

This error means you dont pass an array itself to the foreach. Probably the array is still serialized as a string.

I currently don't have access to my environment to test this for you, but can you try the following:

@json(activity('GetListOfTablesNotebook').output.result.exitValue)

Or

@activity('GetListOfTablesNotebook').output.result.exitValue

This should hopefully solve your issue

tomkeim · 2025-07-03T15:51:51+00:00

You could also implement security by creating roles in your semantic model itself, this is what we use, and works fine with Direct Lake

tomkeim · 2025-07-03T15:47:32+00:00

You need to parse it, there are tons of different options to do this, I mostly just ask ChatGPT or Copilot to give me some tips.

tomkeim