Forum Discussion
Power BI freeze after executing an Edit on Query
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 to...
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.
Mariusz
Community Champion
Community ChampionHi 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.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
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.MS SQL db
im used IMPORT