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.
We have created Power BI dashboard report having 10 controls (Table,Card,Line Chart & Pie Chart) . The data has been imported in Power BI Model which consists of around 12 Entity holding 3 months of data only.pbix File Size is 7 MB as of now .
When the report open ,the control spins and it takes couple of minutes to load the data. We have use IMPORT mode since data volume is not that huge and the SQL view takes time if we go by DIRECT connect .
Dashboard connects to On Prem SQL SERVER with data feed as Views .
Please suggest how we can reduce the render time .
best practices we haev taken care off. Need to know if any setting or hardware need to be upgraded to meet the performance issues.
We are using 8 GB RAM Multi Core Processor.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |