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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MaggieS
Frequent Visitor

R visual error in powerbi service

Hi,

 

I'm trying to use RODBC connecting sql server to pass parameter into table through PowerBI. It worked in desktop, however after published into PowerBI Service, it showed Script Runtime Error. I have confirmed from the Microsoft document that RODBC package is supported in the PowerBI service. I have tried many methods to solve it, such as using personal gateway, connect odbc as one datasource, but none of them have been successful. Apprecieate your advice on how to get this issue resolved or any work-around, thanks.

1 ACCEPTED SOLUTION

I‘ve submitted a ticket and received a response. When the R script attempts to connect to the data source, it initiates a network request. However, network requests from R scripts are prohibited in Power BI service, so it is not possible to connect to the data source and pass parameters through the R script.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @MaggieS ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

 

Best regards,
Community Support Team_Binbin Yu

I‘ve submitted a ticket and received a response. When the R script attempts to connect to the data source, it initiates a network request. However, network requests from R scripts are prohibited in Power BI service, so it is not possible to connect to the data source and pass parameters through the R script.

lbendlin
Super User
Super User

You must use a personal gateway, the gateway must be running, and the required packages must be installed on the PC where the gateway is running.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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