Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.