Automatic Page Refresh on Custom Visual R not working

[naelske_cronos]

Hello,

I have created a custom visual in R and the data I'm using comes from Azure SQL in DirectQuery mode. I'm using automatic page refresh which updates the visual every minute in my dashboard.

The visual is actually refreshing every minute in Power BI desktop but not in Power BI service and I was wondering if something needs to be added in the code to use APR in the service. All other default visuals like tables, filters and charts are updated but not my custom visual in R.

I used the custom visual Icon Map and this is working perfectly in the service also using DirectQuery and the same columns.

Is it possible to create APR on a custom visual in R?

Thank you!

[Anonymous]

Hi @naelske_cronos ,

Considerations and limitations

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

Here are some offical blogs about custom R visual and automatic page refresh in Power BI. I hope they could help you.

For reference:

Create and use R visuals in Power BI

Automatic page refresh in Power BI

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[naelske_cronos]

I checked the documentation again and it's stated that R visuals are not supported in DirectQuery: https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals#considerations-and-limitations

I know that in Power BI desktop it works. It sends my queries in my R custom visual to the SQL database and back to render the visual but when checking it out in Power BI service with the SQL Profiler nothing happens. Why does Power BI service blocks everything if it comes to using R visuals...

Only other way I can still think of is by testing it out with a PUSH dataset.

[naelske_cronos]

Hello @Anonymous ,

I've read the documentation but it doesn't help me any further. By interactivity I presume you cannot click on the visual and highlight/filter blocks but that's not the intention. My R custom visual is intended to be a monitoring visual that updates every one minute.

It's not a default R visual but one I've created myself with RHTML and the automatic page refresh in DirectQuery on the Power BI desktop works fine.

Kind regards

Kevin