Forum Discussion
Applying Queries stuck with Creating Connection Model
Hello Lydia,
Yes, I did delete these columns and rows in Query Editor of Power BI Desktop after importing all the data. Normally everything takes around 20-30 seconds to pull the data, build the model and connections, finish all the calculations and visualise it. I do know it takes a performant machine and use an 8 processor 32GB RAM machine for it.
Since you mention it, I am reducing the columns in my query and try to promote the changes from Query Editor. But that is exactly causing the issue. That's what I did to improve the performance. I let it run for several hours with no success. So now I had to get drastic and go to manage relationships, delete the concerned query there, then apply and reconnect all relationships. That solved the problem and that's what I would've expected the Apply&Close to do as well. I do not have access to the API to modify the columns, but I modified the query to only pull the fields I want by including "?fields=..." in the request URL and it works like a charm.Regards,
Jens
jsteinigen,
Do you delete these columns and rows in Query Editor of Power BI Desktop after importing all the data? If so, this operation and other transformations( merge/appen queries, etc.) will consume memory and cause the performance issue as you describe.
Is there any possibility that you limit the columns and rows in the web API url when you import data to Power BI?
Regards,
Lydia
Hello Lydia,
Yes, I did delete these columns and rows in Query Editor of Power BI Desktop after importing all the data. Normally everything takes around 20-30 seconds to pull the data, build the model and connections, finish all the calculations and visualise it. I do know it takes a performant machine and use an 8 processor 32GB RAM machine for it.
Since you mention it, I am reducing the columns in my query and try to promote the changes from Query Editor. But that is exactly causing the issue. That's what I did to improve the performance. I let it run for several hours with no success. So now I had to get drastic and go to manage relationships, delete the concerned query there, then apply and reconnect all relationships. That solved the problem and that's what I would've expected the Apply&Close to do as well. I do not have access to the API to modify the columns, but I modified the query to only pull the fields I want by including "?fields=..." in the request URL and it works like a charm.
Regards,
Jens
jsteinigen I had a similar problem. I"m using the January 2020 version of Power BI Desktop Optimized for Report Server. I created a custom function and used it to create a custom column in my query. It ran fine in the query editor but when I try "Close and apply" it always crashes in the "Creating connections in model" step.
Based on your post, I went into the Data Modeling view and deleted the table from the data model. Then I could do "Close and apply" from the Query editor without an error. But the data was not part of the data model any more. I thought I would try to add it back. The only way I could find to do that was to go in to Query Editor again. Right-click the query and set the properties to load the table. Then when I tried to refresh the report, again it died in "Creating connections in model"
Were you able to add the problematic table back to the model? If so, how did yoiu do it?