Forum Discussion
Only load 100 rows in load mode
Hi Experts,
I am using PowerBI desktop to load data from Azure SQL with import mode. My SQL table is really big, after I enter server IP, user and password, it seems PowerBI wants to load all the data from SQL table. It takes a long time to wait for system response.
Is there any way to set a limitation on it, only take first 1000 rows, and this setting only effective at desktop. After I publish the report to PowerBI service, the dataset on PowerBI service can still get all the data from source system.
Tom Li
the first time you can let it refresh and you publish it and then i assume you want to set up a scheduled refreshed sometimes during non working hours?
7 Replies
- LivioLanzo
Solution Sage
You can limit the number of rows returned with Power Query, if query folding is happening then an SQL TOP 1000 statement is sent back to the server. YOu can then update the query right before publishing it to the service.
LivioLanzo, thanks for your quick reply.
Would you please guide me how to do such setting at power query? Would you please explain in details?
Thanks.
- LivioLanzo
