"Object (data) not found Execution halted"

[rdides]

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.

[rdides]

Bump

[v-yuezhe-msft]

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

[rdides]

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:

long	lat	DMA Number	group	X1	DMA Tier	DMA Name	DTC Penetration Levels
-83.2864	38.60018	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.6158	38.68465	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.6447	38.52566	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.9279	38.49336	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.9972	38.42132	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-84.1706	38.48591	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-84.2052	38.58279	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-84.4133	38.5654	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-84.7947	38.33934	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.0779	38.57783	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-84.9392	38.65235	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.0259	38.76166	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.1992	38.6921	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.205	38.9132	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.4477	38.9132	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.4419	39.19641	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.2975	39.26845	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.2975	39.52433	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.0374	39.52681	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-85.0316	39.72804	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-84.812	39.72555	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-84.8178	39.56656	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.5753	39.5442	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.5927	39.37776	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.3731	39.37776	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.3846	39.0548	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.2691	39.01506	515	515.1	16	C	CINCINNATI	(0.47-0.821)%
-83.2864	38.60018	515	515.1	16	C	CINCINNATI	(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!

[pdacheva]

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