Power BI freeze after executing an Edit on Query

[Anonymous]

I have a large table, i reduced the number of rows from 52m to 25m

everything went fine. but now when i make Edit Query and apply the changes it takes long time and keep counting the rows then towards the end power bi freezes and nothing happens, changes are not applied. i left the frozen screen for more than 10 hours at night , but the same result. 

can anyone help with this??

[Mariusz]

Hi @Anonymous 

Try to optimize your model, please see the below article.

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

 I tried what the article suggest, but still have same problem exists. Just a side note, my PBIX file size is 1.2 GB

[Mariusz]

Hi @Anonymous 

What is the data source?

Best Regards,
Mariusz

Please feel free to connect with me.

[Anonymous]

MS SQL db

im used IMPORT

[Mariusz]

Hi @Anonymous 

How many columns in this table?

Best Regards,
Mariusz

Please feel free to connect with me.

[Anonymous]

8 columns.

do u think the following will help:

using Sql server database connector instead of "ODBC" connector. 

[Mariusz]

Hi @Anonymous 

Yes definitely try that, you should be getting better performance from SQL Server Connector.

Best Regards,
Mariusz

Please feel free to connect with me.

[Anonymous]

Can i change that now, already i imported the data. can u guide me how change???

[Mariusz · Accepted solution]

Hi @Anonymous 

Please see the link.

https://community.powerbi.com/t5/Power-Query/Changing-data-connection-from-ODBC-to-SQL/td-p/216017

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.