Dataflows Gen2 - Variable Library - Service Principal (SPN) support
Currently, Dataflows that use Variable Library integration can only successfully refresh if the refresh is not using an SPN for authentication.
We need the ability to use SPN for authentication.
3 Comments
- miguelCommunity AdminStatus changed:NewtoNeed Clarification
Hi! is the ask here to support SPN for the run / refresh of a Dataflow? or to support SPN for anything related to variable libraries?
- frithjof_vCommunity Champion
The Dataflow Gen2 Variable Library documentation lists a limitation: Dataflows can only refresh successfully if the refresh is not authenticated using a Service Principal (SPN).
This idea proposes lifting that limitation. The documentation states this constraint here:
More broadly, there is a need to deploy, run, and authenticate Dataflow Gen2 using Service Principals or Workspace Identities, without relying on an Organizational (user) account.
In practice, this means enabling Dataflow Gen2 to run in Test and Production environments entirely without a user account, using only non-interactive identities.
- miguelCommunity AdminStatus changed:Need ClarificationtoAbandoned
Apologies for the confusion. The limitation is actually inherited by the Dataflow itself and not imposed by the Variable library integration with Dataflows.
This documentation article lists the limitation on how you cannot use an SPN to trigger a refresh at this moment:
Background Jobs - Run On Demand Execute - REST API (Dataflow) | Microsoft Learn
We're working towards a plan to faciliate the SPN refresh, but don't have an ETA for it.
Will be declining this idea based on how its framed, as this is not a limitation imposed by the variable libraries, but we can continue the conversation about having dataflows support SPN on the idea below:
Run Dataflow Gen2 as Service Principal - Microsoft Fabric Community
Recent ideas
Power BI Report Builder - Difficult to Use and Ugly.
So I've definitely been spoiled in the modern age. So many apps that are integrated well with top-notch UI, and intuitive processes. Power BI Report Builder is surprisingly lacking in this. While I a...rs_rae2 hours agoAdvocate INew2Views0likes0CommentsIndividual L/R column borders for Matrix
Add Power BI feature for applying left and/or right borders to individual matrix columns, with customizable border thickness and color. This would let users visually group related measures, highlight...AaronReasoner6 hours agoNew MemberNew4Views0likes0CommentsSupport Git-Integrated Files in Fabric Workspaces
Overview Allow users to store and manage arbitrary files such as .md, .sql, .py, and .yml directly in a Fabric workspace, with built-in Git integration. Value This would keep documentation, SQL sc...ryomaru082510 hours agoAdvocate INew39Views4likes1CommentConsistent Locale Handling Across Power BI, Fabric, PowerPoint, and Subscriptions
Microsoft Fabric and Power BI should provide consistent locale handling across all user experiences. Today, locales such as German (Switzerland) are correctly respected in Power BI Desktop and the Po...Le_M12 hours agoRegular VisitorNew22Views1like0CommentsIn Data Pipelines, Schedules should not be part of the definition
The request is to ensure Schedules are not included in the definition of a Data Pipeline for purposes of Deployment Pipelines. Today, when we deploy content across environments, the item frequent...schneiw13 hours agoAdvocate IVUnder Review814Views25likes3Comments