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 guys, just reaching out to see what people's experience is with larger PBIX models.
We have a file c.750MB which we use as a master dataset. So currently we have 2 layers, a report PBIX connected to a dataset PBIX.
The problem were finding is the speed of use of the dataset PBIX.
One consideration is to have a third layer
Report PBIX
Datamodel (containing measures)
Dataset (without measures)
So essentially we would develop
our queries and relationships in the Dataset,
the measures in the Datamodel
the visuals (plus any local measures in the Report).
It does sound complex, but wondered if anyone else has any tips for improving performance.
User | Count |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |