Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Unable to use VNET gateway with Dataflow

Hi, I have a VNET connection that works wonderfully with data sets, but it does not show up when I try to create a dataflow using the same sources. "(none)" is listed in the dropdown even though the gateway exists and is in active use by a dataset in the same workspace.

 

I feel like I am missing something obvious.

 

Thank you!

  • Hi Anonymous,

     

    what data source are you using? Next to that, consider the following:

    • Please note that the list for supported datasources is slightly smaller for dataflows then for datasets.
    • Also, VNET gateways are only supported in Power Platform dataflows.
    • Lastly (also on the docs):  VNet data gateways can only be used in Power platform environments in the home region of your tenant.
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks, nickyvv ! I am trying to connect to an Azure SQL database. I saw the stuff about Power Platform, but thought I had missed something else.

     

    I will mark this as a solution.

     

    Cheers,

     

    Jamie

6 Replies

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional

    Hi Anonymous,

     

    what data source are you using? Next to that, consider the following:

    • Please note that the list for supported datasources is slightly smaller for dataflows then for datasets.
    • Also, VNET gateways are only supported in Power Platform dataflows.
    • Lastly (also on the docs):  VNet data gateways can only be used in Power platform environments in the home region of your tenant.
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, nickyvv ! I am trying to connect to an Azure SQL database. I saw the stuff about Power Platform, but thought I had missed something else.

       

      I will mark this as a solution.

       

      Cheers,

       

      Jamie

    • Ash_mak's avatar
      Ash_mak
      New Member

      Is the above still true in 2022/23? I'm trying to set a vnet gateway that should be visible in the project options dropdown of a dataflow table within the Power BI Service but cannot find a way to see it.

       

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable

        Did you determine if this was possible? I am not seeing the data gate way when I try to configure in power bi service. (source databricks, Vnet data gateway, power bi premium)

  • Who all gets frustrated when you Google search for a problem, get a hit like this one with the exact same problem as I'm having, see that it's marked as resolved...and yet there is zero resolution?  Like...not even a semblance of a solution.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      There is no solution...still. nickyvv answered my question, but MS has yet to fix this.

      Have a very nice day.