Forum Discussion

Anonymous

Not applicable

7 years ago

R script do run on Power BI Service

Hello PBI Experts, MVPs,deldersveld I have a query related to R integration in Power BI. Need immediate help!! I have created a dashboard on Power BI. There is a live direct query connection ...

Tips and Tricks

Community Support

7 years ago

Hi naveen_koushal,

Have you installed and configured data gateway on your server? Also check if you have configure the data source in "Manage Gateway" in power bi service.

Regards,

Jimmy Tao

Anonymous
Not applicable
7 years ago
Hi Jimmy,

Thanks for the support!

Could you please more elaborate why do we require data gateway?. My data is already connected with azure sql database. And the error that comes is related to 'ODBC connection failed'.

Appreciate if you elaborate the possible solution.

Regards,
Naveen
- deldersveld
  Resident Rockstar
  7 years ago
  I don't believe you'll be able to setup and use an ODBC connection in Power BI Service.
  
  The gateway is required in general for an R script in Power Query, but it sounds like you have this RODBC connection setup on an R Visual. That wouldn't need a gateway, but again, I don't believe you'll be able to configure ODBC since you don't have access to configure anything in the Service.
  - Anonymous
    Not applicable
    7 years ago
    Thanks Delsdersveld. I thinkg I should test running the dashboard after installing Gateway. I will get back to you with my findings.
    Regards,
    Naveen
- v-yuta-msft
  Community Support
  7 years ago
  Hi naveen_koushal,
  
  Please refer to this similar thread: https://community.powerbi.com/t5/Service/Publishing-R-visual-into-Power-BI-Service-Run-time-error-RODBC/td-p/475079.
  
  Regards,
  
  Jimmy Tao
  - Anonymous
    Not applicable
    7 years ago
    Hi v-yuta-msft,
    
    Thanks for your reply. There is no solution out there in the thread you shared.
    
    Please suggest if you have some solution.
    
    REgards,
    Naveen

Related content