Forum Discussion

Qmars007's avatar
Qmars007
Frequent Visitor
7 years ago

Data modeling: R script error in Power Bi

Hello, I try to run a simple regression script in Power BI but I get this message in Power BI: DataSource.Error: ADO.NET: R script error. Error in eval(predvars, data, env) : object 'price' not fou...
Data Modeling
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Qmars007,

 

The summary (regression) result you mention is returned in R studio Console pane not in Plots pane. You need to ensure the result can be plot in Plots pane in R studio, then you can use the R script in Power BI to visualize data. For example, in my previous post, I use abline() to plot a chart. 

 

Best Regards,
Qiuyun Yu 

Qmars007's avatar
Qmars007
Frequent Visitor
7 years ago

Hi Qiuyuan,
Thanks for your prompt response.
My aim is to display the summary of my regression analysis in Power BI as it does appear in R studio pane rather than the graph of the correlation between the two explanatory variables.
How can this be done? 
Thanks very much
Qmars

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Qmars007,

     

    Till now, it's almost the R issue instead of Power BI visual. As I mentioned before, you might need to write R script to ensure Summary(regression) result display in Plots pane within R studio. Then you can use the same script in Power BI desktop to plot the visual. 

     

    Best Regards,
    Qiuyun Yu 

    • Qmars007's avatar
      Qmars007
      Frequent Visitor
      7 years ago
      Thanks for your message. Would you be able to let me know "how to write R script to ensure Summary(regression) result display in Plots pane within R studio" in a way that I can see the executive summary of regression analysis? Kind regards Qmars