Hi I have just started facing this problem recently. i need to pull about 7.5M rows (15 columns, 8 are date/numeric). My Dataset is likely to grow to 14.5/15M rows by the year end. I get my data ...
v-qiuyu-msft
Community Support
Community SupportHi shaherbano,
Please refer to this document to optimize your data model: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
From your description, it looks like the personal gateway runs on a different machine from the SQL database server. Please contact your network admin check if there is any network issue when the error occurs. You can take a look at this document: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance#gateway-best-practices
Best Regards,
Qiuyun Yu