Forum Discussion

AkhilThogari's avatar
AkhilThogari
Regular Visitor
2 years ago

Unable to import data from dataflow Gen 2 into Power bi desktop.

Hello Team,

 

Help me, When I am trying to import data from Dataflow Gen2, In the Navigation window it shows an error

 

'Microsoft SQL: A network or instance-specific error occurs while establishing a connection to SQL Server ......'

 

I am unable to see the Table inside the Dataflow also,

 

Attached screenshot.

Dataflows

6 Replies

  • pqian_MSFT's avatar
    pqian_MSFT
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hey,

     

    This can happen if your firewall blocks access to the SQL endpoint of staging lakehouse. You should allow traffic on port 1433 to flow to it.

     

    ·       Protocol: TCP

    ·       Endpoints: *.datawarehouse.pbidedicated.windows.net, *.datawarehouse.fabric.microsoft.com, *.dfs.fabric.microsoft.com

    ·       Port: 1433

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      2 years ago

      Hi AkhilThogari 

       

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
      In case if you have any resolution please do share that same with the community as it can be helpful to others.

      Otherwise, will respond back with the more details and we will try to help.


      Thanks.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        2 years ago

        Hi AkhilThogari 


        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
        If you have any question relating to the current thread, please do let us know and we will try out best to help you.
        In case if you have any other question on a different issue, we request you to open a new thread.


        Thanks.

  • nxlu's avatar
    nxlu
    Frequent Visitor
    2 years ago

    Bumping this, still having issues connecting to Gen 2 Dataflows as well from desktop

     

    Is this still the recommended fix?

     

       Protocol: TCP

    ·       Endpoints: *.datawarehouse.pbidedicated.windows.net, *.datawarehouse.fabric.microsoft.com, *.dfs.fabric.microsoft.com

    ·       Port: 1433

    • pqian_MSFT's avatar
      pqian_MSFT
      Icon for Microsoft Employee rankMicrosoft Employee
      2 years ago

      Yes. To be clear: the problem will exist as long as your network does not have a line of sight to the warehouse\lakehouse.

  • frithjof_v's avatar
    frithjof_v
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Did you try writing the outputs of the Dataflow Gen2 to Lakehouse table?

    (Add data destination)

     

    Then connect Power BI to the Lakehouse table(s).

     

    Unless you are writing the outputs of the Dataflow Gen2 into a data destination, I guess you could might as well use a normal Power BI Dataflow?