I have a large .pbix file that is causing problems. It performs fine when I load it with say 5M rows, but when I load it with say 50M rows, and I interact with certain measures, then it freezes my entire machine. No CTRL-ALT-DEL, no keyboard, no mouse, no nothing. Machine is completely locked, so I must hold down the Power button to shut down, and then reboot.
My impression is that the application is overwhelmed by computations and completely locks up or at least claims ALL of my computer's resources - and that this situation is not detected or trapped by the application. This situation is NOT preceeded by the "Couldn't load the data for this visual" memory warning.
I understand that measures and data models can be optimized, and that every application will have its performance limitations, etc. Without getting into measure details, I have some general questions:
Q1: Has anyone run into this sort of complete lockup when the application is overloaded?
Q2: Is there a clever way out of these situations other than leaning on the Power button?
Q3: Should the application be expected to trap these situations better?
Fact table has 50M rows, file size is 140MB.
PBI desktop Version: 2.42.4611.901 64-bit (January, 2017)
Intel Core i7-6820HQ 2.7 GHz, 16 GB RAM