Forum Discussion
Power BI Direct Query Measure Issue with 1M rows...
Hello Anonymous,
I already have unrestricted measures with direct query ON...
Referring to the bullet:
There is a 1 million row limit for returning data when using DirectQuery. This does not affect aggregations or calculations used to create the dataset returned using DirectQuery, only the rows returned. For example, you can aggregate 10 million rows with your query that runs on the data source, and accurately return the results of that aggregation to Power BI using DirectQuery as long as the data returned to Power BI is less than 1 million rows. If more than 1 million rows would be returned from DirectQuery, Power BI returns an error.
My dataset is not returning more than 1 million rows... it is a simple count measure for a filtered table...
I guess there must be something happening in between that is invalidating this. Would be interesting to debug it.
Hi Anonymous,
I find your have invoked other measure as the condition for filter, I'm not so sure combine use multiple measures with caused the issue.(if other measure has some operation will loop all table with complex operations)
Regards,
Xiaoxin Sheng
Hi Anonymous,
The other measure is also very simple:
Measure X = CALCULATE(DISTINCTCOUNT('Table1'[ID]); 'Dim1'[Atribute1] = "FilteredValue")Hi Anonymous,
I found your measure calculate through multiple tables, I think the issue may related to loop calculate, count of the calculate exceed the 1M.
For example:
Table1, 10k + rows, dim table, 100k+, loop calculation count 10K *100K=1MRegards,
Xiaoxin Sheng
And this is something normal and acceptable using DQ?
This is something that should be able to work properly on the product since I am not returning more than 1M rows but yes calculating using joined tables that exceed 1M rows... This scenario is very common, no one is having this kind of issue?
Thank you