Forum Discussion
PowerBI Online Refresh Issue
hi Anonymous
For big dataset refresh issue, you could try these way:
1. Filter your dataset and optimize your data model as below:
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
2. use directquery instead of import
3. change the Query Timeout in eidt queries, please refer to these post:
https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459
https://community.powerbi.com/t5/Desktop/ODBC-amp-OLE-DB-Timeout-Errors/td-p/460648
Regards,
Lin
hi Anonymous
For big dataset refresh issue, you could try these way:
1. Filter your dataset and optimize your data model as below:
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
2. use directquery instead of import
3. change the Query Timeout in eidt queries, please refer to these post:
https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459
https://community.powerbi.com/t5/Desktop/ODBC-amp-OLE-DB-Timeout-Errors/td-p/460648
Regards,
Lin
Thank you a lot for your advise, I will try each method