Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Direct Query Preview - Input query length exceeding the supported maximum length

I'm attempting to use the Direct Query preview feature that allows adding additional tables to an exsiting dataset and relating them. When I connect a new table to an existing table the report works fine and allows me to build any kind of visualization without issue using any field from either dataset. However, when I filter the new table with a field from the existing table(s) (there is a 1 to many relationship) I get the following error:

 

Input query length exceeding the supported maximum length.
RequestId: TDS;db6d47a3-32a9-42db-b34a-47b6efdc129e;2
Time: 2021-04-26T17:37:51.5467482Z. The exception was raised by the IDbCommand interface.

 

Existing Dataset:

Account List - 180K rows - Azure SQL

New Table:

List of Opportunties - 300 rows - Dynamics365

 

This seems like a limitation in how the Direct Query is pulling the existing dataset. Any help is greatly appreciated.

Status: New
Comments
v-chuncz-msft
Community Support

@alexhameltrox 

 

I cannot reproduce the issue. You may try the latest version of Power BI Desktop and share feedback via Ideas.