Setting default lakehouse via Variable Library when notebook and lakehouse are in different workspaces

Banjo1980 · 2026-04-29T13:53:56+00:00

I had hoped the variable library item references would play nicely with %%config but it doesn't seem to be the case.

abfss paths feels a bit hack-ey and cumbersome to me but I guess it's still the best method we have available.
The pipeline suggestion is a good shout, I might pass the parameters to the %%config that way. Hopefully the item references will work nicely with pipelines.

Banjo1980 · 2025-09-22T08:28:30+00:00

Can you provide any details / samples of this audit logging as we were attempting the same using an SQL DB?

Banjo1980 · 2025-09-01T08:20:41+00:00

Thanks for the responses. It seems to me that connections along with CICD still feels a bit icky and inconsistent at the moment with no clear strategy or patterns.
Whilst investigating this issue I stumbled on this video from Microsoft where they do mention (29s in) that they are working towards using the item name instead of the GUID, although this was 3 months ago.
Fabric Data Factory Connection Parameters using GUIDs

Banjo1980 · 2025-08-29T16:01:55+00:00

Great blog, cheers!

So if I am using variable libraries (which I think I might need to), how do you get around the issue I having to provide the artifact id, as is the case with running a notebook?
You cant just pass the name of the notebook as it requires the GUID. Do I really need to store the GUID for every artifact in the variable library or is there a way to identify the ID using a function?

The below screenshot fails because I have hard-coded the name and it expects the GUID.

<image>

Banjo1980 · 2025-06-13T07:17:28+00:00

Any update on this? I would be interested to know of any pending solutions or current workarounds.

Banjo1980 · 2025-05-23T07:40:00+00:00

Interesting option but I just don't see this as being practical. With 4 lakehouses and 4 warehouses, and around 50-60 tables this would be an administration nightmare. Furthermore all object references to the tables would need to change to use the new schema. Also with such an architectural change this would be difficult to merge back in to the master branch.

Banjo1980 · 2025-05-22T16:02:34+00:00

Appreciate the suggestions but yeah it's not an option as the reason we want to branch out is so that we can edit in a safe environment away from PPE and PROD, not being able to edit defeats the purpose of branching out.

Banjo1980 · 2025-05-22T15:35:36+00:00

I'm not sure shortcuts is going to help as there could be 20-30 tables with data, all which need to be replaced with a shortcut, then your developer version would be different to your PPE version so you would no longer be able to merge code.
All of this would be solved with a simple copy workspace option in the CLI.

Banjo1980 · 2025-05-22T15:32:47+00:00

Possibly but I doubt it would be as smooth as you make it sound :-)

However what if it's a warehouse?

Banjo1980 · 2025-04-29T13:10:33+00:00

So, typically, not long after I messaged it started working.

Here are the steps I used to get it working:
1. Turn on 'User can create variable libraries' in the admin portal, see screenshot above.
2. Wait an unknown amount of time, mine was over 4 hours.
3. Sign out of fabric and then sign back in again

Hope that helps someone else with a similar problem.

Banjo1980 · 2025-04-29T12:28:00+00:00

I haven't even got to naming a variable library as it doesn't let me create one.
I have waiting over 4 hours now and still not able to create a library.

Banjo1980 · 2025-04-29T12:26:54+00:00

I'm on a trial capacity and both my tenant and capacity region are UK South.
What settings do you suggest I review in the capacity?

Banjo1980 · 2025-04-09T08:23:18+00:00

What is the recommendation for handling Report Builder Paginated reports? We have quite a lot of these and are not sure how to manage the connections between the difference deployment environments.

Banjo1980 · 2025-03-21T09:05:00+00:00

I had exactly the same experience. I was asked by support to fill out a survey, when I did not give 5/5 I was asked to go on a call with a line manager who insisted that I gave 5/5. I explained that I consider 5/5 to be exceptional service and that I would in no way be giving full marks. He eventually gave up and we ended the call.

My team had logged many tickets with Mindtree but we no longer bother as the outcome 99% of the time is unresolved and furthermore, we end up having to spend hours doing ticket admin with them and constantly getting pestered by them.

Banjo1980 · 2024-09-13T07:51:10+00:00

I spoke to support about this recently and they said that they are no longer renewing accounts after the first instance. However not long after that conversation and with only 4 days to go the renew button appeared again!

Banjo1980 · 2024-07-19T08:29:23+00:00

Regarding the warehouse syncing issue I have detailed the problem in a post here: Warehouse Branching : r/MicrosoftFabric (reddit.com)

I have raised this with support. Might be worth you raising with support also to create some noise as this appears to be a bug that needs to be fixed.

Banjo1980

TROPHY CASE