Forum Discussion
Shared Master Data Model Performance?
The DirectQuery just means that it will always get the data from the master model.
In Power BI the master model is an in memory database which caches the queries, so when users are using the same report it will get the results from the query cache, which is very fast and does not impact performance.
I for example have a client that has got one master database that has got over 100 reports connected and they all run very fast.
I would highly recommend going with the master model approach it works well and it is fast.
The DirectQuery just means that it will always get the data from the master model.
In Power BI the master model is an in memory database which caches the queries, so when users are using the same report it will get the results from the query cache, which is very fast and does not impact performance.
I for example have a client that has got one master database that has got over 100 reports connected and they all run very fast.
I would highly recommend going with the master model approach it works well and it is fast.
Thank you so much for the quick answer on this, search the entire internet for hours and could find nothing even remotely answering this question!