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 ...
shaherbano
Microsoft Employee
Microsoft EmployeeThank you for the response. I will go through both. Personal gateway on my machine as currently due to limitations i cant install on the Server. but when i refresh my desktop file, why do 7.3 Million rows take 1 hour ?
These times are refreshing PBI desktop file:
1. Evaluating: 15 mins
2. Waiting for "server name": 12 mins
3. loading rows: 12 mins
My dataset will reach max of 15M rows, with about 15 columns out of which 8 are numeric/date. How many rows or file size can PBI handle ? I do most calcs in DAX to avoid importing extra columns.
Thank you for your help and for this amazing product.