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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Access github content PowerBI Service

Im trying to access some data on github raw content, for a custom visual i have created on R, which works great for powerBI desktop, but cant get it work in PowerBI Service. I get this runtime error 'Cannot open data source' message fallowed by: GDAL Error 1: Couldn't resolve host 'raw.githubusercontent.com'. Its just free access content, any help appreciated. 

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @Anonymous ,

Please check whether the custom visual by using R hit any following limitations which refer in this official documentation:


  • R visuals support is limited to the packages identified in Learn which R packages are supported. There currently is no support for custom packages.

  • Data size limitations – data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB.

  • Resolution - all R visuals are displayed at 72 DPI.

  • Plotting device - only plotting to the default device is supported.

  • Calculation time limitation – if an R visual calculation exceeds 60 seconds the script times out, resulting in an error.

  • R visuals are refreshed upon data updates, filtering, and highlighting. However, the image itself is not interactive and does not support tool tips.

  • R visuals respond to highlighting other visuals, but you cannot click on elements in the R visual in order to cross filter other elements.

  • R visuals are currently not supported for the Time data type. Please use Date/Time instead.

  • R visuals do not display when using Publish to web.

  • R visuals do not support renaming input columns. Columns will be referred to by their original name during script execution.

  • R visuals currently do not print with dashboard and reports printing

  • R visuals are currently not supported in the DirectQuery mode of Analysis Services


Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Dear yingr thanks a lot for the replay!. 

 

Ive read the limitations, but as you can see in my previous message, this is a situation that arises only with powerBI Service. Dont know if "R visuals do not display when using Publish to web." applies when regular publishing through "premiun channel"(Premiun content). The error message declares incapacity to connect to the host, even thought i can get the custom visual working, connecting correctly to the host, in PBI Desktop. Is there an additional limitation to accessing external data sources, on custom visuals in particular, when publishing? I cant find anything on the web related to this specific issue.

 

FYI this is a visual that uses plotly html content to display maps. I need to somehow connect to geojson data to generate the polygons of regions in Chile. What i did was to locate data in github which R can access with no problem. If there is another solution to how to access this external data, like connecting to Azure Cosmos in the custom visual, ill be glad to hear! 

 

Havent found anywhere (but with no much importance but still) how to change the encoding of content beeing displayed on custom visual either (I cant enforce it. In the Rscript I declared UTF-8 encoding which works great in Rstudio but doesnt on PBI Desktop). 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors