About Error Solution For Refreshing datasets+dataflows

[fazor_liu]

Q: The error message is: This operation has been canceled because there is not enough memory to finish running it.

Is there a solution that doesn't resize the memory? The number of columns in a query have a big impact?

[Idrissshatila · Accepted solution]

Hello @fazor_liu ,

it's not a best practice to get everything into Power bi,

you need to limit the data in terms of having only the records relative to your analysis, so filter down data.

you also need to remove columns that you don't need.

create a star schema data model https://youtu.be/7ciFtfi-kQs?si=OqCHLl8sPiYrT60u

also check this for Power bi optimization
https://www.linkedin.com/pulse/power-bi-optimization-framework-ahmad-chamy-nensf/

[muhssamy]

you can first select only the columns you need and fix data types issues first.

Do Some columns tuning like remove time from date time columns or split it to 2 columns.

Also you can round decimal numbers to 4 digits for example.

if all this not enough and you have premium capcity . implement incremental refresh 

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn