Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/
In this article, it mentioned "There is a 1 million row limit for returning data when using DirectQuery", is that true? if so, what does it mean exactly?
Solved! Go to Solution.
Hi @katherine2999,
There is a 1 million row limit for returning data 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.
Yes, that's true. That is to say, you cannot return more than 1 million rows from your data source, then process those rows on Power BI side. But you can make aggregations or calculations against more than 1 million rows with the query which will run on the data source side, and return the result to Power BI side.
Regards
Hi @katherine2999,
There is a 1 million row limit for returning data 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.
Yes, that's true. That is to say, you cannot return more than 1 million rows from your data source, then process those rows on Power BI side. But you can make aggregations or calculations against more than 1 million rows with the query which will run on the data source side, and return the result to Power BI side.
Regards
Hi,
can I make calculations with the query which will run on the data source side?
Thank you in advanced
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.