Forum Discussion
Only load 100 rows in load mode
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?
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, thanks for your suggestion, I found such Top N setting, I set N as 100 and finish my report.
Another problem is, before I publish report, I removed above setting, but when I click publish button, system asked me if I need to apply this change or not.
I clicked apply later, then the Top N setting still works at PowerBI server.
If I clicked apply button, then I need to wait for a long time because PowerBI desktop tring to download all data from database.
I am tring to find a solution to only apply changes but not refresh data. :(
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?