Forum Discussion
About Error Solution For Refreshing datasets+dataflows
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/
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