I connect my sql database to Power BI. I got sth like 80.000 rows and I have two additional calculated columns that get previous vales. Here is a code Table.AddColumn(#"Added Custom", "prev_action3", each try #"Added Custom" { [Index] -1 } [Action Type] otherwise null) " When I click close & apply I got stuck in "Creating connection in model" with over an hour now with nooutput. Without 2 columns close &apply cost like 1-2 minutes. I already tried this one https://community.powerbi.com/t5/Desktop/stucking-on-creating-connection-in-model/m-p/276796 , but it does not change anything.
Tried the Solution above, still doeswn't work. Stuck at Creating Connection in Model.
This is happening after September2021 update of PowerBI Desktop.
I tried degrading to previous version od Power BI Desktop(August2021) Version. It is fixed now.