Forum Discussion
Work around for RODBC connection on Power BI Service
Hi, Anonymous
Based on your description, the overtime of R visuals is 60 seconds and it is fixed If an R visual calculation exceeds 60 seconds, the script times out and results in an error.
There are also some limitations on R scripts.As you know, the sandbox approach imposes some restrictions on the R scripts running in the Power BI service, such as accessing the Internet, or accessing to other resources that are not required to create the R visual and they can't be changed. I wonder the requirements you want to achieve. Maybe there is a workaround by using other visuals.
Best Regards
Allan
Hi Allen,
Thanks for the reply.
I will need slicers or drop down lists which has functionality to pass into parameters and then query on a fact table which is huge(14 million of rows and hundreds of columns). The dataset obviously can't be pulled into power bi desktop in one go therefore I used R visual as the work around to only pull the summary the user need into powerbi desktop (that's right the slicers / drop down lists provide users with the options to customise their summary e.g. the total sales(one of options) by years(one of options) by states(one of options) with certain filters applied(one of options)).
Is there any other smart tricks / visuals that will allow this user interaction to happen on power bi service.
Best regards,
Kevin