Power BI - Trendline exploration

Hi Linuu ,

Yes, this approach can generally work in DirectQuery mode as well. Since the regression logic is being applied on aggregated results rather than raw row-level data, it is usually compatible with DirectQuery models.

In some cases, errors can occur when the DAX logic becomes too complex for DirectQuery processing, especially when multiple table transformations or intermediate calculations are involved.

A few workarounds that may help in this scenario are using a numeric sequence column instead of relying only on a text-based Month-Year field, keeping the calculations measure-based and as simple as possible, and building/testing the logic incrementally when introducing more advanced calculations.

For more information, please refer to the official documentation:

• Analytics pane:
  https://learn.microsoft.com/power-bi/transform-model/desktop-analytics-pane

• DirectQuery limitations:
  https://learn.microsoft.com/power-bi/connect-data/desktop-directquery-about

If possible, please share the exact DAX error message or the measure definition you are using so the issue can be narrowed down further.

Hope this helps.

Best Regards,
Abdul Rafi