Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.