Forum Discussion
Lakehouse SQL to Dataflow Keeps Failing
Hello, For the last few days I am getting a failed Gen 1 Dataflow when returning a table from an SQL table in my Fabric Lakehouse. DataSource.Error: Microsoft SQL: A transport-level error has...
v-cboorla-msft thanks for reply I really do appreciate it however unless I have misunderstood your reply it would be great if you understood my issue fully.
Network issues will not be an issue as this is all housed within the Microsoft environment on a P2 SKU, I am querying data from a SQL table in a Fabric Lakehouse using a Dataflow, the query itself is not complicated at all containing just one where clause and returning less than 10,000 results.
Server Issues not sure how this can be a problem as the SQL database itself is currently only being queried by this dataflow. Also there is absoluteley no issue using a Power BI Desktop file to do the same thing.
Look forward to hearing from you.