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.
I tried the below R script in two different places on PowerBI but it gives me a different results
on Get Data > R script, the following R script returns a dataset that I can explain and eventually parse JSON format.
On the other hand, when applying this on Run R Script within Transform - it doesnt return any dataset that I can do further transformation. Basically returns no rows. What have I done wrong? Please find R script below. Note that I took away my API key 🙂 - Many thanks
# 'dataset' holds the input data for this script
library(rosetteApi)
key <- "content"
value <- "It is a beautiful day"
parameters <- list()
parameters[[ key ]] <- value
parameters <- toJSON(parameters)
result = api("my api", "sentiment", parameters)
myjson <- toJSON(result)
dataset <- as.data.frame(myjson)
From what I've been able to determine at this point you need to return a data.frame named exactly "output".
So I usually start with:
output <- dataset
# do manipulations add columns etc... to the output data frame
@Anonymous
The R script under "Get Data" is for importing the resulting data frame. But the R script in Query Editor is only for performing transformation and shaping data.
Reference:
Running R Scripts in Power BI Desktop
Regards,
hi there
Im aware of that, however my problem is why one gives me an error and the other doesnt so it must be a bug?
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |