Josiah on 11 May 2017 18:07:50
Make retrieving JSON Rest APIs less memory intensive so it can be done more efficiently.
I'm not totally sure if this is a bug or a feature request, but when I connect PowerBI to our SQL data source, I can load hundreds of thousands of rows without an issue. If I call our REST API of the same data source, I have to make 500 calls to get the data and memory usage of PowerBI spikes, quickly consuming all my Ram, Page File, and can even bluescreen my PC. I've seen memory usage top 40GB on a dataset that is less than 2GB. The created table is identical, but the REST API consumes much more memory and is much slower.