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 establish...
Dataflows
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.