Stucking on creating connection in model - Power BI

0
votes

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.

2
powerbidatamodel

2 Answers

0
votes

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.

0
votes

Haven't tried it yet (I've got the same problem), but you can get older versions from here: https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-desktop

Woo! Worked first time after installing August 2021. Looks like something broken in Sept 2021