Forum Discussion
Solved
rsQueryTimeoutExceeded
Hello, I am experiencing a critical performance and resource exhaustion issue when attempting to force the use of an inactive relationship in a DAX measure for invoicing/billing. The goal is for the...
Hi jesushmmadrid ,
Using a Composite Model can definitely help in separating the date logic while still keeping both fact tables consistently filterable, and applying group by/ summarize patterns in key measures can also reduce the size of the filter context and improve performance.
Please follow these articles for reference :
Optimization guide for Power BI - Power BI | Microsoft LearnData reduction techniques for Import modeling - Power BI | Microsoft Learn
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Regards
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you