Forum Discussion
Impactful Individualimport mode or composite model
i am using snowflake as data source for Power BI . I used to receive around 3000 records on daily basis in snowflake . Power BI license is premium P1 capacity. if I go with import mode then the data size is crossing 1 GB limit ( even with incremental refresh as well) . The increased data size is making difficult for report developer to do the development in power bi desktop because of lmited computer RAM and processor issue. I am confused how to handle this issue. should I still go with import mode or I should go with composite model ( keeping fact in direct query mode and dimensions in import mode)
powerbiexpert22 Semantic models in the Service can exceed 1 GB in Premium (Fabric) capacities. But sounds like that a composite model is really your only option here if it is causing problems in Desktop. Alternatively, check to see if you have unused columns in your semantic model. PowerOps is a great tool for this. powerops.app. Also, make sure that you actually need the current level of granularity in your fact table(s) or if you could possibly summarize the data on import.
1 Reply
- Greg_Deckler
Community Champion
powerbiexpert22 Semantic models in the Service can exceed 1 GB in Premium (Fabric) capacities. But sounds like that a composite model is really your only option here if it is causing problems in Desktop. Alternatively, check to see if you have unused columns in your semantic model. PowerOps is a great tool for this. powerops.app. Also, make sure that you actually need the current level of granularity in your fact table(s) or if you could possibly summarize the data on import.