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 UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor3 hours agoSuper UserNew3Views0likes0CommentsPower BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor3 hours agoSuper UserNew4Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell5 hours agoNew MemberNew3Views0likes0CommentsPower BI Desktop Data Load: Can We Get Better Progress Visibility?
One UX improvement I’d really like to see in Power BI Desktop is better visibility when loading large datasets from Power Query. Currently, when Power Query finishes processing and the data starts l...salmansaifee776 hours agoRegular VisitorNew16Views0likes0CommentsImprove support for calculated tables on remote semantic models
When a report is connected to a remote semantic model, Power BI Desktop allows users to create calculated tables and calculated columns based on that remote model. The issue is that this architectur...alaeddinegaaya9 hours agoNew MemberNew10Views0likes0Comments