Forum Discussion
Direct query issue
Hello folks, I am new to power bi and i went along with the idea that direct query would help my users to be self sufficient. (Real time data) now that i am working direct query i feel the do...
doing many to many both ways on your modeling will cause performance problems on directquery. It may really make more sense for you to use staged data - depending on how 'fresh' the data needs to be you can do ensure your data refreshes happen so that the users are happy with how current the data is. Having an indicator of when a report was last refreshed allows the customer to see that. If this is purely a PBI desktop use case, the user can decide when to refresh. Directquery sometimes becomes a larger problem given you can't do a lot of the flexible things that the import model gives you. Another option is to look at storing your data in a SSAS model - there you have more options around aggregations, etc..
Good luck!