Forum Discussion
Freezing date-table
Anonymous
This issue seems more related to your computer environment, have you try with a PC instead of a laptop. The speed of calculation or operation is pretty much depended on your computer processor, CPU, RAM, etc. you could create a support ticket from Power BI team for further analysis: https://powerbi.microsoft.com/en-us/support/
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @V-pazhen-msft,
Thank you for your response. I am having the same date-table on a data model that is over 1 GB and it works as expected. However, as soon as I send it over to my colleague and get the PBI file back, the date-table starts to freeze. This is very strange, because the data model can be as small as 1,9MB and it still does the same. This happens only with the date-table from SQLBI and not with any other table. Hence, I don’t think its computer’s performance issue here.
I was wondering if some part of SQLBI forces the DAX validation to rerun multiple times? It seems so when the PBI unfreezes and I click on a row with the DAX-code it freezes instantly for a while. I can post a picture of what I see when it gets frozen.
Here is a link to SQLBI calendar mentioned above.
Best regards,
AntonHere is a figure with the issue. I am able to scroll around, but whenever I click anywhere in the window with the DAX code it freezes for a while. I can't get my head around this issue. Has anybody else had the same issue? The data model is less than 2MB here, so it shouldn't be an issue. I am running on Lenovo ThinkPad T480s with Intel Core i7 8th generation.