Forum Discussion

MaggieS's avatar
MaggieS
Frequent Visitor
3 years ago
Solved

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....
  • MaggieS's avatar
    MaggieS
    3 years ago

    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.