How can we improve Power BI?

Allow non-admins to see enterprise gateways in dataflow creation

According to my experience and the documentation, only admins of enterprise gateways can see gateways during the dataflow creation process. Can this not be opened up to report authors as well? Our enterprise gateway is controlled by IT and has one or two administrators. "Self-service ETL" won't be realized unless report authors can create dataflows using the enterprise gateway.

118 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

8 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    This does not make sense. Please fix this. Handing out GW admin rights to everyone who creates dataflows??

  • SamRock commented  ·   ·  Flag as inappropriate

    Yes... Strange, I can access Gateway connections to schedule my Dataset but not use the same to create a Dataflow?

    Please give us a Dropdown list of all the Approved Gateway connections - we will pick an already configured connection.

    Also why again ask for server name, DB name , user name and password? We should be able to just select a pre-configured Gateway connection

  • Joel commented  ·   ·  Flag as inappropriate

    Can we please be careful with the options around this. As the keeper of the enterprise data governance, i use dataflows as a way to open up safe governed datasets to the business users, mastered from the data warehouse and leveraging the existing ETL work. If anyone can create a dataflow then we're back to data governance issues. As admins we really need the ability to control who can create dataflows. Fine if that's a few more than have access to the EGW but please can we put this in the tenant settings or somewhere.

  • Matt Bleiweiss commented  ·   ·  Flag as inappropriate

    Is there any updates as to timing of this feature? It is critical in order for my organization to begin utilizing data flows

  • Jack Wells commented  ·   ·  Flag as inappropriate

    Great to see progress is being made on this one. I think this will give a boost to the potential capabilities of citizen developers.

  • Anonymous commented  ·   ·  Flag as inappropriate

    so far, I voted yes. but wondering what are the considerations from the other to design so?

  • Anonymous commented  ·   ·  Flag as inappropriate

    For now, as the preview version, to create an on-premise dataflows, it requires the permission to have the gateway admin permission, which contradicts the idea of self-service BI. Hopefully, gateway admin permission is not necessary as long as this user has the "use" permission on this gateway.
    ---------------------------------
    Quote "Only gateways for which the user is an administrator appear in the drop-down list."
    from the document link, https://docs.microsoft.com/en-us/power-bi/service-dataflows-on-premises-gateways#using-an-on-premises-data-source-in-a-dataflow

  • Jack Wells commented  ·   ·  Flag as inappropriate

    It's crazy that I can create multiple datasets that query the same datasource through a gateway but I can't setup a dataflow to reduce the duplication of these queries.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.