Forum Discussion

jkraush1's avatar
jkraush1
Frequent Visitor
9 years ago
Solved

Query Editor R Script errors

I uploaded a .xlsx file into Power BI desktop and tried to run a simple R script on it in query editor as a test run. Specifically the script I ran was: # 'dataset' holds the input data for this ...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi jkraush1,

     

    I got the same error when using above script. In my test, the Date column is set to DateTime, formatted as "1/1/2017 5:20:20AM".

     

    Please try below code.

    Hour=format(as.POSIXct(dataset$Date, format="%Y-%m-%d %H:%M:%S"), format="%H")

     

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi jkraush1,

 

I got the same error when using above script. In my test, the Date column is set to DateTime, formatted as "1/1/2017 5:20:20AM".

 

Please try below code.

Hour=format(as.POSIXct(dataset$Date, format="%Y-%m-%d %H:%M:%S"), format="%H")

 

Regards,
Yuliana Gu

jkraush1's avatar
jkraush1
Frequent Visitor
9 years ago

Hello v-yulgu-msft,

I used that code and thankfully it does not return the same error as before. However, it seems to result in PowerBI outputting an empty table. In fact, I have tried a few other lines of code in R script and the result seems to always be a blank table with only empty columns for 'name' and 'value'. Any idea why this is happening?