Hi @Anonymous ,
This is a limitation.
Limit of 1 million rows returned on any query: There's a fixed limit of 1 million rows placed on the number of rows that can be returned in any single query to the underlying source. This limit generally has no practical implications, and visuals themselves aren't going to display that many points. However, the limit can occur in cases where Power BI isn't fully optimizing the queries sent, and there's some intermediate result being requested that exceeds the limit. It can also occur while building a visual, on the path to a more reasonable final state. For example, including Customer and TotalSalesQuantity would hit this limit if there were more than 1 million customers, until some filter were applied.
The 1 million row limit can be exceeded in Premium capacities. For more information, see max intermediate row set count.
For more detail you can refer this article.
Using DirectQuery in Power BI - Power BI | Microsoft Docs
The same problem has been solved in this post, you can refer.
https://community.powerbi.com/t5/Service/Direct-Query-1-million-row-limitation-in-Power-BI-Premium/td-p/847202
RANKX:
This function is not supported for use in DirectQuery mode when used in calculated columns.
You can change DirectQurey mode to Import model.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
