Power BI Python and R Visual not showing on PowerApps

[Ascii0007]

I have a Python and R chart/visual that was plotted in Power BI desktop and published to the web service. The chart works just fine on both Power BI desktop and web but it doesn't show when I used the Dashboard in my Canvas app. Every other thing works fine on the Power BI tile in the canvas app except the Python and R visual. 

[v-yueyun-msft]

Hi , @Ascii0007 

I test it in my side , the R visual can show in my Power App :

And it didi not show in the selection field. We can first select one of the tile in dashboard.

Then we need to get the tile id in Power Bi side:

Then we need to replace the tile id in the Power BI tile control - TileUrl:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[Ascii0007]

The title of the visual shows but not the chart. Still not working on my end. I can't post pictures because of sensitive information on the report.

[v-yueyun-msft]

Hi , @Ascii0007 

I can not reproduce your issue in my side , can you try to open the developer tool in your browser setting?

And then you can re-put the whole code in your TileUrl property and check if it return some error in API?

Best Regards,

Yueyun Zhang

[Ascii0007]

I'd try this when I get back to work. However, I can post the R code that is used to plot the graph. The parameters  AE & Average. P is decimal while BrewDate is DateTime. It's a line chart with as many as 15 data points:

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:

# dataset <- data.frame(BrewDate, AE, Average P.)

# dataset <- unique(dataset)

# Paste or type your script code here:

# Load required libraries

# Load required libraries

# Load required libraries

# Load required libraries

# Load required libraries

# Load required libraries

# Load required libraries

library(ggplot2)

library(scales)

# Convert 'BrewDate' values to datetime objects

dataset$BrewDate <- as.POSIXct(dataset$BrewDate)

# Sort the data by 'BrewDate' to ensure x-axis alignment

dataset <- dataset[order(dataset$BrewDate), ]

# Plot the data

p <- ggplot(dataset, aes(x = BrewDate)) +

  geom_line(aes(y = AE), color = "blue", linetype = "solid") +

  geom_line(aes(y = `Average P.`), color = "red", linetype = "solid") +

  geom_point(aes(y = AE), color = "blue", shape = 4) +  # Use shape 4 for blue marker

  geom_point(aes(y = `Average P.`), color = "red", shape = 4) +  # Use shape 4 for red marker

  scale_y_continuous(name = "AE. P", sec.axis = sec_axis(~., name = "Temp. Celsius"),

                     breaks = scales::pretty_breaks(n = 20)) +  # Adjust the number of breaks on y-axis

  scale_x_datetime(breaks = "1 day", date_labels = "%b %d") +  # Adjust the breaks on x-axis

  labs(x = "Brew Date") +

  theme_minimal() +

  theme(axis.text.x = element_text(angle = 45, hjust = 1),

        panel.grid.major = element_line(color = "gray", linetype = "dotted"),  # Add major gridlines

        panel.grid.minor = element_line(color = "gray", linetype = "dotted"))  # Add minor gridlines

# Print the plot

print(p)

[v-yueyun-msft]

Hi , @Ascii0007 

Thanks for your response! Sorry for that i am not familiar about R script in Power Bi side. I just download the R visual sample pbix file in document to test in my side.

So in my thought , you can also download the file in this document to test in your side to check if it can show in your dashboard to exclude the code issue?
Create advanced analytics and visualizations using R scripts - Power BI | Microsoft Learn

Best Regards,

Yueyun Zhang

[Ascii0007]

Apparently, I utilized the Power BI file with the R code in the link you shared, imported it to my Canvas app and the R Code is not showing. Apparently, the problem is not with the R code but with something else, maybe the environment. I attached pictures of the PBIX file on the webservice and canvas app