Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Direct Query loses a lot of performance when I have a cross-filter. I have an oracle based my fact table with 50 million records.
Hi @sergiobramil,
In my opinion, what you get is expected. The performance of the interaction in DirectQuery mode depends on the performance of the underlying data source. As all data is imported, large amount of data will cause lots of time to query. For more information, see: Important considerations when using DirectQuery.
Best Regards,
Qiuyun Yu
Certainly the performance using direct query and smaller with respect to the imported base, but the question is not direct query with respect to the imported base, but the direct query with relationship with direction of the filter in both. When it matters the relationships comes filter dirreção in both, but in direct query comes all in single. Changing to both the performance is impractical in relation to the single.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
140 | |
109 | |
103 | |
82 | |
73 |