Forum Discussion

yoshihirok's avatar
yoshihirok
Post Prodigy
10 years ago
Solved

R script for starting.

I want to a R script for starting R script in Power BI Desktop. Just like "Hello World" of some programming language.   I want to start the R language by Power BI Desktop.   Example:   How to t...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    I suspect querying the Iris data set is the closest thing to a hello world in R (it's a built in set of data on flower petal sizes, kind of the R equivalent to Adventureworks). Try this as a script.

     

    class(iris)
str(iris)

IrisInput <- iris
rpowerbi's avatar
rpowerbi
Advocate I
10 years ago

Is there a way to connect to the Sql Server Analysis Cube or Tabular Model from R

Please let me know if you have a sample script to connect to SSAS

 

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
10 years ago
rpowerbi wrote:

Is there a way to connect to the Sql Server Analysis Cube or Tabular Model from R

Please let me know if you have a sample script to connect to SSAS

 

 

Thanks

I would assume so although I've never investigated how to do the query directly.

If I wanted to do it and was feeling lazy about it I'd use something like the above code to run an SQL query and then use Openquery in the SQL to query the cube.