Skip to main content

Power BI

Needs Votes

Make built-in Power BI forecast capability available through Power Query/M function for data transforms

Vote (4) Share
Rui Quintino's profile image

Rui Quintino on 03 Aug 2020 15:06:43

Power BI has a very reasonable and easy to use (though very often hidden!) built-in forecast capability,

*but* currently this is only available with specific line charts (see analytics tab), and it's only a visual forecast (though today we can at least export the values)

Idea is to make the same model/algorithm available through PowerQuery (including model parameters), so the resulting forecast could be handled as a regular power bi data table.

Similar request exists for Dax also, please vote here :) :
https://ideas.powerbi.com/ideas/idea/?ideaid=74dca84e-ad01-4345-9dfd-b13fc42536d5#submit-comment

Note: some more info on Power BI forecast (rather old though, not 100% sure reflects current algorithm, if anyone as better info/refs)
https://powerbi.microsoft.com/es-es/blog/describing-the-forecasting-models-in-power-view/
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane