Forum Discussion
Can i use R if my source is live SSAS?
I have a .pbix with some data regarding leads and I wanted to add some ML to predict whether the lead is likely to buy…
I have experience in R, but not that much in Power BI.
(If I were to use only R, it is pretty simple since my dataset would be a .csv file and all computation is done locally…)
In my .pbix I am consuming live data from an SSAS. (I have Power BI premium).
I have the below questions:
- Can I run a R script in the case my source is SSAS live?
- Given the fact that I have Power BI premium… is it better me writing the R code to predict if the lead will buy or shall I use some sort of “packed” service within Power BI Premium that already does this…
Hi ovonel,
I see a similar question over here:
Does the answer there resolve your question as well?
Hi, Anonymous
You can run R in live SSAS.
The scene of R used in powerbi:
Use R in Power Query Editor - Power BI | Microsoft DocsCreate Power BI visuals using R - Power BI | Microsoft Docs
Since your data source is live ssas, then we don't talk the first feature. As for the second feature, you can try it and use R to create forecast data in visual.
Create advanced analytics and visualizations using R scripts - Power BI | Microsoft Docs
Of course, you can also try to use the ML function in premium, here are some tutorials for reference:
Tutorial: Build a Machine Learning model in Power BI - Power BI | Microsoft Docs
Use Machine Learning and Cognitive Services with dataflows - Power BI | Microsoft Docs
If you still have problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- timg
Solution Sage
Hi ovonel,
I see a similar question over here:
Does the answer there resolve your question as well?
- v-janeyg-msft
Community Support
Hi, Anonymous
You can run R in live SSAS.
The scene of R used in powerbi:
Use R in Power Query Editor - Power BI | Microsoft DocsCreate Power BI visuals using R - Power BI | Microsoft Docs
Since your data source is live ssas, then we don't talk the first feature. As for the second feature, you can try it and use R to create forecast data in visual.
Create advanced analytics and visualizations using R scripts - Power BI | Microsoft Docs
Of course, you can also try to use the ML function in premium, here are some tutorials for reference:
Tutorial: Build a Machine Learning model in Power BI - Power BI | Microsoft Docs
Use Machine Learning and Cognitive Services with dataflows - Power BI | Microsoft Docs
If you still have problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.