Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Art
Frequent Visitor

Problem running an R Script to read a JSON file and create a dataframe in power BI

I am gettting the below error while running my R script in power BI . The script runs fine in R studio. In the options in power BI I have specified the right path for R-3.5.0

 

unable to connect

we encountered an error while trying to connect

Details: "ADO.NET: R script error.
Error: lexical error: invalid char in json text.
output10.json
(right here) ------^
Execution halted
"

The first few line of code are below 

 

library(jsonlite)
library(plyr)

P<-fromJSON("output10.json")
summary(P)

 

Anybody know why ?

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.