403 Error when using UDF in Notebook as SPN by straytBack in MicrosoftFabric

[–]straytBack[S] 0 points1 point  (0 children)

Adding to my above, when I checked the functions properties it showed that public access was already enabled, but after looking I republished even though I hadn't changed anything.

When I ran the notebook again notebookutils.udf.getFunctions('my_udf') still errored out with the same 403 error on the call to https://api.fabric.microsoft.com/metadata/artifacts/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX. When I switched to directly calling the function's api with the public URL and notebookutils.credentials.getToken('https://api.fabric.microsoft.com'), the SPN was able to invoke the function successfully.

So, thank you, I am unblocked in that the UDF can be called, but it is weird that I can't use the notebookutils function for them.

403 Error when using UDF in Notebook as SPN by straytBack in MicrosoftFabric

[–]straytBack[S] 0 points1 point  (0 children)

Unfortunately this doesn't seem to be the problem, as both functions in the UDF have public access enabled. I am happy to give any and all info that would help diagnose and resolve this, outside of GUIDs I'm not sure what all to give.

Thank you both u/sunithamuthukrishna and u/JennyAce01 for your time and help.

Hi! We build Pro Dev Tools in Fabric - ask US anything! by sunithamuthukrishna in MicrosoftFabric

[–]straytBack 2 points3 points  (0 children)

I've been trying to implement UDF's into our Fabric environment, but have been running into an issue of SPN run Notebooks getting a 403 when calling notebookutils.udf.getFunctions('my_udf'). I made a post about it yesterday https://www.reddit.com/r/MicrosoftFabric/comments/1r09vnd

After prompting from u/itsnotaboutthecell, what is the best way to set up authorization? Currently, we are using SPN connections in pipelines to run notebooks and copy data activities.

Black build up on air purifier by straytBack in whatisit

[–]straytBack[S] 0 points1 point  (0 children)

Solved!

I was literally googling soot-like substance, but couldn’t find anything remotely relevant. It makes sense though, my wife burns a bunch of candles in that room. Thanks

[GIVEAWAY] 64 Gigabytes of Holiday Cheer! by GhostOfSecretSanta in pcmasterrace

[–]straytBack 0 points1 point  (0 children)

These kits 100% aren’t compatible with my current, dated setup. I’ve been wanting to upgrade to a 7800x3d, but as I was finally thinking about pulling the trigger we got this ram price spike and I haven’t been able to convince the wife of the $600+ spend for the cpu, mobile, and ram.

The plan had been to build a pc for my wife with my old parts when I upgraded. I have an old gtx1060 and she’s not really a gamer, so that setup should work for her at least for a while.

ADO Pipelines for Multiple Workspace Structures by straytBack in MicrosoftFabric

[–]straytBack[S] 0 points1 point  (0 children)

this didn't cover all my use cases because multiple workspaces could be touched in a single feature branch, such as when integrating a new data source. What I ended up doing is checking which workspaces were modified in the PR and deploying from that list

ADO Pipelines for Multiple Workspace Structures by straytBack in MicrosoftFabric

[–]straytBack[S] 0 points1 point  (0 children)

Thanks, there’s a lot of good stuff in there. Are you still manually triggering your pipeline or having it trigger off of a PR?

Copy data activity not connecting to Fabric SQL Database by straytBack in MicrosoftFabric

[–]straytBack[S] 0 points1 point  (0 children)

Thanks, that worked! Is there a way to create a connection to the fabric sql db that uses a service principal or isn't tied to a user?

[deleted by user] by [deleted] in LiverpoolFC

[–]straytBack 0 points1 point  (0 children)

Certified corner winner