Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to run statistical models in R query editor so that the output can be put into a new column or table. For instance, I want to run an ARIMA forecasting model but I want the forecasted values to go into a new column that I can use in Power BI's line chart. Another example is visualizng summary results from a linear regression like if I wanted to plot the residuals using Power BI scatterplot. The reason for doing this is gain the interactivity that Power BI visuals have. R visuals lack this and currently Power BI does not support the Plotly library.
Solved! Go to Solution.
Hi @shj997,
In this scenario, you can run R in the Power BI Desktop Query Editor. This integration of R into Query Editor lets you perform data cleansing using R, and perform advanced data shaping and analytics in datasets, including completion of missing data, predictions, and clustering, just to name a few. For more details about this, you can refer to this article.
Regards
Hi @shj997,
In this scenario, you can run R in the Power BI Desktop Query Editor. This integration of R into Query Editor lets you perform data cleansing using R, and perform advanced data shaping and analytics in datasets, including completion of missing data, predictions, and clustering, just to name a few. For more details about this, you can refer to this article.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |