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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rdides
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
rdides
New Member

Bump

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.

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!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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