Forum Discussion

01_RAF_01's avatar
01_RAF_01
Frequent Visitor
5 years ago

Odata refresh issue

Hi, i have set up a odata connection succesfully in powerbi desktop. I can access data and build a report etc. Refresh on powerbi desktop also is no problem. However, when i publish it to powerbi service and want to setup auto refresh daily i cant get it done. 

It asks me to adjust my references and i tried all these options. Also when entering my credential i get this error:
"OData: Request failed: Unable to connect to the remote server"

 

Anyone experienced this also or know what to do? 

Need Help
Tips and Tricks

10 Replies

  • collinq's avatar
    collinq
    Super User
    5 years ago

    Hi 01_RAF_01 ,

     

    Do you have a gateway setup?  This errors seems to be that the data source is "local" and that you do not have a method of the service reaching the data source.  

    • 01_RAF_01's avatar
      01_RAF_01
      Frequent Visitor
      5 years ago

      Hi collinq ,

      no i dont have a gateway setup. The datasource isnt local. I connect to the data through an external url with login credentials. On powerbi desktop it connects normally. When trying to input my credentials here is doesnt recognize it/ gives me the error: "OData: Request failed: Unable to connect to the remote server"

      • collinq's avatar
        collinq
        Super User
        5 years ago

        HI 01_RAF_01 ,

         

        You might want to check the Data Credentials for the Data Source in the DataSet settings to confirm that it is using the right credentials.

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi 01_RAF_01 

    Is the data source type you connected in Power BI Desktop OData Feed ?If it is ,you need configure gateway with OData data source in Power BI Service . In this way, it can refresh automatically .

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • 01_RAF_01's avatar
      01_RAF_01
      Frequent Visitor
      5 years ago

      hi Anonymous ,

      Will this also work when my laptop is not turned on? 

      Im trying to see if i can set it up....i downloaded the personal mode and installed it... but when trying to configure a gateway in powerbi service i get an error that i dont have a gateway... Never used gateways before to be honest...

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi 01_RAF_01 

    In fact, I recommend that you use an enterprise gateway. Personal gateway just supports Import mode .You can see the difference between two gateways.

    You can refer the link to configure enterprise gateway

    https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-app

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi 01_RAF_01 

    Have you tried the standard gateway ? Can your report refresh successfully in Service now ?

    If yes, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards

    Community Support Team _ Ailsa Tao

    • 01_RAF_01's avatar
      01_RAF_01
      Frequent Visitor
      5 years ago

      Hi Anonymous ,

       

      unfortunatelly no solution yet. Im only able to install the personal gateway. 

  • ABEZZI's avatar
    ABEZZI
    New Member
    5 years ago

    Hi,

     

    I have exaclty the same issue with my odata connexion refresh.

     

     

    Is their any solution proposal for this issue ?

     

    Thanks.