Menu
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.
264
2222.0 of September's 2021 PBI Desktop). Probably your problem was connected with the input file, as "Creating connection in model" status is a standard status observed when connecting to the data source. It looks like it could be. Getting data out of Sharepoint is notoriously slow.
Using too many graphics, too much data, using non-certified custom graphics or leaving the default options are some examples of practices that can lead to Power BI having to make an extra effort to load our report and therefore increase the time the machine needs to load.
Import is the most common connectivity type used in Power BI and the default selection when connecting to most data sources. The most important aspect to know about when using an Import is that all data ingested is stored in the Power BI model, therefore the PBIX file and hosted in memory.
In Power BI you will find the option under File > Options and settings > Options > Data Load > Data Cache Management Options > Clear Cache.
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.
195
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
22
This is a bug from PBi but nothing is wrong
If you already had this report going well before :
Power BI decided (or not) to not show anymore the numbers of rows it is counting.
You feel like it's stuck and not working anymore --> do not worry, still going the same speed as before, it is just not telling you
Here are some links on the question :
Power Bi community : creating connection
Reddit : creating connection
22
Same here, stuck on creating connection in model on MYSQL database after Sept2021 Update. Can't believe I have to downgrade it...
Edit: Got it to work downgrading to August version.
30
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
