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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.