Forum Discussion
dmkblesser
Advocate II
Advocate IIAny best practice for using direct query connection?
The company has decided to use direct query to connect to the cloud data source for its tracebility. We are aware of the 1 million rows limitation and the potential slowness when querying data from t...
aj1973
Community Champion
Community ChampionA limit of 1 million rows can return on any query. There's a fixed limit of 1 million rows that can return in any single query to the underlying source. This limit generally has no practical implications, and visuals won't display that many points. However, the limit can occur in cases where Power BI doesn't fully optimize the queries sent, and requests some intermediate result that exceeds the limit.
Meaning if you have optimized queries then the implications are null