Forum Discussion
Dataverse table access fails with TDS error 8657 in Fabric Dataflow
The issue has been resolved with a workaround. I split the source query into two smaller queries and then joined them back together, keeping the existing final table structure unchanged. This avoids the TDS connector error caused by the large number of columns in the project table.
The data is now refreshing successfully.
Microsoft still needs to investigate and resolve the underlying Dataverse connector/TDS issue because I am still unable to preview the data through the normal Dataverse connector.
Update: The Project table issue has been resolved with a workaround. I split the source query into two smaller queries and then joined them back together, keeping the existing final table structure unchanged. This avoids the TDS connector error caused by the large number of columns in the project table.
Microsoft still needs to investigate and resolve the underlying Dataverse connector/TDS issue because I am still unable to preview the table data through the normal Dataverse connector. The Azure team has submitted a Microsoft Support ticket and will update us when they receive feedback from Microsoft.