Import data whose size exceeds the limit

Question

I want to import a 500 GB dataset into Power BI, but Power BI is limited 1 GB. How can I get the data into Power BI?

Answer 1

​Chop your dataset into 500 sets, each of 1GB instead of 1 set of 500GB

or 

you could use Direct Query mode, the 1 GB limit does not apply to Direct Query.