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
Set default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg6 hours agoNew MemberNeeds Votes7.8KViews1154likes104CommentsTable Visual — Rounded Corners and Pill-Style Cell Backgrounds
Add the option to display cell background colors as rounded rectangles or pill-shaped labels within the native Table visual. Currently, applying a background color fills the entire cell with a solid...urawizardharry7 hours agoRegular VisitorNew10Views0likes0CommentsAdd Global Alignment Controls for Power BI Matrix Values and Headers
Please add a global alignment setting for Matrix visuals that allows users to apply the same alignment, left, center, or right, to all measure columns at once. This should apply to column headers, d...AaronReasoner8 hours agoNew MemberNew5Views0likes0CommentsCase sensitive-insensitive option in Power BI
There should be an option in Power BI for the data in the columns to be either case sensitive or insensitive. When one deals with data involving client names or entity names, case sensitivity-sinsens...sohail_syed_moh8 hours agoNew MemberNeeds Votes2.3KViews124likes11CommentsGoverned & Regulation for Publish to Web feature
Notifying certain group of individuals if there is any enhancements performed on the semantic model which already hold an active Publish to Web code in place. This ensure in having more security and...Jaswanth_UNHCR9 hours agoNew MemberNew6Views0likes0Comments