Forum Discussion
Tom_Li
7 years agoFrequent Visitor
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...
- 7 years ago
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
7 years agoSolution Sage
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?
Tom_Li
7 years agoFrequent Visitor
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.
- v-cherch-msft7 years agoMicrosoft Employee
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