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?
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?
LivioLanzo, Thanks.
Your understanding is correct, and I think I need to let it refresh at desktop and do a schedule at Power BI Service.
It is the solution so far. Thanks.
Hi Tom_Li
It seems you've got the answer,right? If so, please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.
Regards,
Cherie
