cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

"Object (data) not found Execution halted"

Hi Guys!

 

I'm new to R Studio and Power BI. When I try to run the script from R, I get the error message "Object (data) not found Execution halted" when the files necessary to complete is loaded. Can anyone help? Image for more information.

 

PowerBIIssue.JPG

4 REPLIES 4
Highlighted
New Member

Bump

Highlighted

Hi @rdides,

Have you run the R script in R Studio and checked if it works well?

The above error could be caused by incorrect syntax in the R script, could you please share some sample data and R script so that we can try to reproduce?


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

The data works in R! I just ran it once more.

 

Here's the code:

library(dplyr)
library(plotly)
library(scales)


ggplot(DMAMappingData,aes(long,lat))+
geom_polygon(aes(fill=`DTC Penetration Levels`,group=group),colour=I("white"))+
geom_polygon(data=States, aes(long, lat,group=group, colour = I("black"))
,alpha=0)+
coord_map("albers", at0 = 45.5, lat1 = 29.5)+
theme_bw() + theme(panel.border = element_blank(), panel.grid.major = element_blank(),
panel.grid.minor = element_blank(), axis.line = element_line(colour = "black"),
axis.line.x = element_blank(),axis.line.y = element_blank(),
axis.text.x = element_blank(),axis.text.y = element_blank(),
axis.title = element_blank(),axis.ticks = element_blank())+
scale_fill_brewer(palette = "Set1")

 

 

Sample DMA Mapping Data:

 

longlatDMA NumbergroupX1DMA TierDMA NameDTC Penetration Levels
-83.286438.60018515515.116CCINCINNATI(0.47-0.821)%
-83.615838.68465515515.116CCINCINNATI(0.47-0.821)%
-83.644738.52566515515.116CCINCINNATI(0.47-0.821)%
-83.927938.49336515515.116CCINCINNATI(0.47-0.821)%
-83.997238.42132515515.116CCINCINNATI(0.47-0.821)%
-84.170638.48591515515.116CCINCINNATI(0.47-0.821)%
-84.205238.58279515515.116CCINCINNATI(0.47-0.821)%
-84.413338.5654515515.116CCINCINNATI(0.47-0.821)%
-84.794738.33934515515.116CCINCINNATI(0.47-0.821)%
-85.077938.57783515515.116CCINCINNATI(0.47-0.821)%
-84.939238.65235515515.116CCINCINNATI(0.47-0.821)%
-85.025938.76166515515.116CCINCINNATI(0.47-0.821)%
-85.199238.6921515515.116CCINCINNATI(0.47-0.821)%
-85.20538.9132515515.116CCINCINNATI(0.47-0.821)%
-85.447738.9132515515.116CCINCINNATI(0.47-0.821)%
-85.441939.19641515515.116CCINCINNATI(0.47-0.821)%
-85.297539.26845515515.116CCINCINNATI(0.47-0.821)%
-85.297539.52433515515.116CCINCINNATI(0.47-0.821)%
-85.037439.52681515515.116CCINCINNATI(0.47-0.821)%
-85.031639.72804515515.116CCINCINNATI(0.47-0.821)%
-84.81239.72555515515.116CCINCINNATI(0.47-0.821)%
-84.817839.56656515515.116CCINCINNATI(0.47-0.821)%
-83.575339.5442515515.116CCINCINNATI(0.47-0.821)%
-83.592739.37776515515.116CCINCINNATI(0.47-0.821)%
-83.373139.37776515515.116CCINCINNATI(0.47-0.821)%
-83.384639.0548515515.116CCINCINNATI(0.47-0.821)%
-83.269139.01506515515.116CCINCINNATI(0.47-0.821)%
-83.286438.60018515515.116CCINCINNATI(0.47-0.821)%

 

There is another file it uses in the code named "States" but that lays out the states on the USA. But the problem is with "DMAMappingData not found, so I don't know what the issue is. Thank you for your help!

Highlighted

Hi,

 

I have the same issue with the R visuals and I can't figure out why it doesn't detect my data fields in the data.frame.

Did you get any resolution and if yes, would you mind post it here for further reference?

 

Thanks!

Petya

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors