Forum Discussion
Helper VHow to use Power BI with big data?
Hi bourne2000 ，
Power BI uses the same engine as SSAS, it can handle a LOT.Power BI runs on memory. So the bigger the data set, the more memory it is going to require. Make sure you have plenty of memory, and that you are on a 64 bit system.
Please try switching off Data load property from below settings;
Un-check both these settings.Might be also worth to check out task manager on your machine (CPU usage, Memory usage) see if you don't have any performance issues there.
To learn more details ,refer:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Super Userbourne2000 . 3 M should not be a problem. Just use the column which are needed in power bi in import mode and check. First, check on a desktop with at least 8/16 GB (RAM). Service you can check on PPU trial
With premium you can get capacity, you can choose depending on need
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-faq
you can explore ppu too