Forum Discussion

QooT's avatar
QooT
Frequent Visitor
1 year ago
Solved

Cannot acces Tabels in Dataflow Gen2 from Excel

Hi, I have an Excel File with connection to Dataflow Gen2, query as simple as just load table data. let Quelle = PowerPlatform.Dataflows(null), Workspaces = Quelle{[Id="Workspaces"]}[Data], Wo...
Need Help
  • QooT's avatar
    QooT
    1 year ago

    Problem solved.

    Reason was firewall rule wchich was blocking connection to SQL.

    It seems that behind the scenes connection to dataflow Gen2 is turned on the fly into connection to the staging SQL database.

QooT's avatar
QooT
Frequent Visitor
1 year ago

Problem solved.

Reason was firewall rule wchich was blocking connection to SQL.

It seems that behind the scenes connection to dataflow Gen2 is turned on the fly into connection to the staging SQL database.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    Hi QooT ,

    Thanks for confirming and good to know the issue is resolved.

    Even though the user had the correct workspace permissions, network-level restrictions like firewall rules can still block access when trying to load table data from Dataflow Gen2 in Excel.

     

    Thanks again for the update, this will definitely help others encountering similar behavior. Could you please mark your reply as Accepted Solution to help others with similar issues.

    Also thanks to MasonMA for your valuable inputs.

     

    Please reach out for further assistance.

    Thank you.