Solved: Row's limit

david1sp · ‎08-30-2018

The limit of rows in a dataset with DirectQuery is 1.000.000, but thats all the size of dataset or 1.000.000 rows/update?

v-juanli-msft · ‎08-30-2018

Please check this article, 1.000.000 rows limit should be the rows which returns to the dataset.

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.

Best Regards

Maggie

v-juanli-msft · ‎08-30-2018

Please check this article, 1.000.000 rows limit should be the rows which returns to the dataset.

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.

Best Regards

Maggie

Row's limit