How can we improve Power BI?

Please increase dataset limit of Power Query from current 256MB

I think currently power query starts paging when the size of dataset is more than 256MB. I want to analyze 5 years of data, but as the size of dataset that gets close to or more than 256 MB then power query becomes extremely slow. 1 reach dataset limit of 256MB with just 1 year of data.

The link below also says how power query slows down when it reaches 256MB dataset limit

https://social.technet.microsoft.com/Forums/en-US/d7a858db-9905-4f97-8a77-bed761a92423/questions-about-the-technical-limits-of-power-query?forum=powerquery

Power Query has been an extremely useful tool in automating data cleaning/shaping/transforming. However, when I approach near 256MB it becomes extremely slow. If I add just 1 step when power query is near it's 256MB limit then it would take about 30 mins.

18 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Gaurav Saneja shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.