Forum Discussion
Predictive Modeling in Power BI?
helloWorld - I am not aware of being able to feed anything from Power BI to another program in the way you are describing. I did create a blog article on forecasting with Power BI:
helloWorld - I am not aware of being able to feed anything from Power BI to another program in the way you are describing. I did create a blog article on forecasting with Power BI:
Thanks for your help!
For datasets up to 150k rows you can use some R-trickery in Power BI: http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
On SQL-server-level there is a full R-integration - actually seems to be the fastest R-engine on the market at the moment.
Greg_Deckler 's DAX-forecasts provide some good ground.
M can do all that and a bit more, as it also natively handles recursions and is more versatile in general (but mostly not as fast as DAX). FInd a pattern for a TREND-function here: https://github.com/ImkeF/pquery/blob/master/Stat.Trend.m
As of today we have parameters in PBI giving the users the ability to define filters: So if we can find some volunteers to put the code for all statistical functions together ... :-)
