Forum Discussion
Custom table visual max allowed size
Hi, I am developing a custom table visual to create a writeback solution. I am using Direct Query and a Databricks SQL warehouse as my backend. I keep running into "The resultset of a query to ext...
dm-p Thank the response, I checked the query generated by the visual and the query that is ran in databricks.
The DAX TOPN query defines N as the amount specified in the data reduction algo + 1 so in my case it's 101.
The strange thing is that the query ran in Databricks as has limit of 1,000,001 rows defined no matter what my data redcution algo is set to but when I remove the dimension field the databricks query shows the limit set to 100.
Additionally, what is strange is that the cardinality between the fact and dim table is 46 so it's really small.
Same limit is hit with the standard table so I am guessing this is feature and not an issue with my code.