topic Re: Odata refresh issue in Service

Odata refresh issue

01_RAF_01 — Mon, 21 Jun 2021 07:19:36 GMT

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?

Re: Odata refresh issue

collinq — Mon, 21 Jun 2021 17:50:30 GMT

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.

Re: Odata refresh issue

01_RAF_01 — Tue, 22 Jun 2021 05:16:01 GMT

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"

Re: Odata refresh issue

collinq — Tue, 22 Jun 2021 13:53:06 GMT

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.

Re: Odata refresh issue

Anonymous — Wed, 23 Jun 2021 08:28:33 GMT

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.

Re: Odata refresh issue

01_RAF_01 — Thu, 24 Jun 2021 13:49:39 GMT

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...

Re: Odata refresh issue

Anonymous — Fri, 25 Jun 2021 01:48:12 GMT

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.

Re: Odata refresh issue

Anonymous — Tue, 29 Jun 2021 05:36:08 GMT

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

Re: Odata refresh issue

01_RAF_01 — Tue, 29 Jun 2021 05:59:24 GMT

Hi Anonymous ,

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

Re: Odata refresh issue

ABEZZI — Fri, 23 Jul 2021 09:06:50 GMT

Hi,

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

Is their any solution proposal for this issue ?

Thanks.

Re: Odata refresh issue

sasmita — Thu, 18 Aug 2022 11:54:15 GMT

Is the above issue resolved without using gateway.

Is it possible to do schedule refresh of Odata feed without using gateway. Have gone through the below link but direct connection option is not available for me.

Solved: Re: how to refresh data when i am using data feed ... - Microsoft Power BI Community