If the agent is a human, I'd expect less than 10 mins. If chatbot, immediately.
If the agent is a human, I'd expect less than 10 mins. If chatbot, immediately.
They expire?
Stuff like this shouldn't be that hard. It's like MS is deliberately throwing hurdles in the path to a true enterprise data platform.
The MI is part of the security group in the tenant setting you mentioned and contributor on the workspace, but still the pipeline fails. Annoying. I'm thinking it's the notebook activity in the pipeline that is causing this, hence the need to use a notebook connection.
I'd rather use something that doesn't have secrets that expire. The thing I want to solve is that I want to trigger a Fabric Pipeline from ADF using the ADF managed identity, but for some reason the pipeline fails (again with user token issue).
I get that you need to do this for service principals, but workspace identities? They're part of the system itself (yes, I know they're service principals behind the scenes).
OK, that's annoying as we work with a new workspace for each git branch, and each time adding the workspace identity to the security group is major overhead since we cannot do this ourselves (and we don't have this Entra ID permission at most of our clients)
anyone got the new notebook connection working with a workspace identity from a data pipeline? #microsoftfabric cc @erwindekreuk.bsky.social
You would think that if you run your own #MicrosoftFabric capacity, that queueing would be less...
Oh wait, I've read the entire thing now. Yes, it's that time of the year again π
Nope, we change on the 29th of March.
Iβm Not Gonna Waste Time Debunking Crap onΒ LinkedIn.
LinkedIn is full of absolute trash these days. Just flat out bullshit garbage. (Oh yeah, that - this post should probably come with a language disclaimer, because this stuff makes me mad.) People wanna look impressive without actually putting inβ¦
There are so many of these crap posts nowadays in my feed. "SQL Logical query order" "Why you should use CTEs" "How to remove duplicate rows" and so on. @drsql.bsky.social has apparently the patience of an angel to comment on them to point out mistakes :)
New blog post: #Azure Data Factory Pipeline Debugging Fails with #BadRequest β The Sequel sqlkover.com/adf-pipeline...
New article: Whatβs New in #SSIS2025? (TL;DR not much :)
www.mssqltips.com/sqlservertip... #ssis #sqlserver
What's the point of having a database if the data can't go out? π€ͺ
#MicrosoftFabric community down?
New blog post:
How to Parameterize #MicrosoftFabric Linked Services in #Azure Data Factory for #AzureDevops Deployment sqlkover.com/how-to-param...
Ooo take care. I had kidney stones and I do wish them upon my worst enemies π
It might be my background as an SSIS developer, but I like the clicky-draggy-droppy development in the browser :D
It's not permissions, as it works perfectly fine if I define the git integration manually. The git integration is obviously only for the development environment. ADF code is pushed to the other envs using ARM.
Devops.I specified a custom collaboration branch (adf_main), publish branch is adf_publish, root folder is /adf. All through bicep. When I disconnect to git integration and re-connect, it does work.
I get this nasty error in #Azure Data Factory. Any ideas?
Use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure.
Article + video available!
#powerbi #dax
https://www.sqlbi.com/articles/debugging-dax-variables-using-tojson-and-tocsv/
New article: Develop #SSIS Packages with #sqlserver2025 www.mssqltips.com/sqlservertip... > another SSIS article in my series :)
I did some testing with data clustering in the #MicrosoftFabric warehouse and damn, that database is quite fast on an F2.
Introducing MicrosoftFabricMgmt: Managing Microsoft Fabric with PowerShell
Introduction If you have been following this blog for a while, you will know that I am a huge fan of using PowerShell to manage and automate things. SQL Server, dbatools, dbachecks β auto
blog.robsewell.com/blog/introdu...
Two questions:
1. Can you also use it for Power BI Pro stuff? (I assume yes)
2. If used in Azure Devops, can I use it with a service connection with federated identity, and don't have the need for a secret that expires?
So. Annoying.