Forum Discussion

Anonymous's avatar
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 ...
Need Help
Tips and Tricks
Anonymous's avatar
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

 

 

  • Anonymous's avatar
    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

    • Renu's avatar
      Renu
      Frequent Visitor
      7 years ago

      Hi Naveen,

      Were you able to solve this? We are in the same boat as you and trying to figure out the solution. If you solved it can you please share it with us.

       

      Thanks,

      Renuka

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-yuta-msft 

    Hi Jimmy,

     

    Is there any work around for this that is passing slicer values as parameters into SQL query avoiding using RODBC? I am currently facing the same issue where I need to pass values from a few different slicers e.g. group by factors, filter factors and filter values. These are must-have functionality for my deliverables and they work perfectly in powerBI desktop when using RODBC but not working at all while publishing it to powerBI service.

     

    Any comments or work arounds are appreciated.

     

    Best regards,

    Kevin Zheng