Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 from a SQL view with a simple select *. But pulling into PBI is very slow: following steps take after 1st time load take:
1. Evaluating: 15 mins
2. Waiting for "server name": 12 mins
3. loading rows: 12 mins
However, when loading same dataset with 15 columns (reducing text columns) 1st time takes like 2 hours. Other team member pulls about 24M rows with similar columns but her load time is fairly quick. I am a pro user.
Also i have set up a gateway on my personal machine, which works fine for smaller datasets (upto 2.5M rows datasets havent had troubles). but I got this error description with my 7M rows (35MB file report)
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.