Shared Workspace Publish - Direct Query Using SQL

[SachinC]

Hi,

Am I correct in saying using the shared workspace publish from PBI desktop, DQ uses TOP 1000 rows in SQL?
Please can you guide me to a document to validate?
Thanks!

[GilbertQ · Accepted solution]

Hi there

Currently there is a limit of 1 Million rows for items

And here is a link to where I got the image: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about