Forum Discussion
Queries over large data tables
We have a large dataset of unstructured data (Azure Blob) and have started noticing that refreshing our model gets quite slow after a few thousand records are being loaded. Our current query stru...
While we are discussing options to turn off parallel processing with the teams involved, there's a workaround for your scenario. You can set an environment variable in the PBIDesktop.exe process to go back to sequential loading.
For example, in the command prompt, you can:
> SET PBI_EnableMultithreadedDataLoad=0
> PBIDesktop.exe
Thanks pqian!
This was quite helpul to better follow the execution order, and even helped us pinpoint a few inneficiencies in our queries :) As it stands I don't think what we're trying to do with Power BI is quite possible, but it helps to know we do need an extra layer to process our data!