Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
We have purchased Premium with P1 tier. we have created a common data model in import mode with 2 facts (60M records & 20M records) and 8-10 dimension tables. we have created around 80-90 measures used across 10 reports. we have published this datamodel to a workspace and started using it in other reports by using "Power BI as a data source" - Live connection. there will be 500-800 end users but started noticing heavy performance hit even to filter a region. we have RLS in place.
The question is, will this common data model & Live connection is a good architecture?
how to improve the performance? and what went wrong in your opinion?
Thanks in Advace.
Regards,
Deva
Hi @dekalya ,
With Power BI dataflows,you can customize your entities based on your unique needs.
https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/
https://docs.microsoft.com/en-us/power-bi/service-dataflows-overview
Or you can try saving the report as a template file, then modifying the template file and republishing it to the workspace.
Import Data is the fastest possible option. Data is loaded into the memory of the server and all queries will be resolved immediately.Live connection is the second choice.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @V-lianl-msft,
Thanks for the reply. We are having snowflake as a datasource - which is not supported by Dataflows.
Agree that the Import Data is the fastest, but how many reports / users can access a same Import - Data Model at a same time?
We are trying to improve the performance here.
Regards,
Deva