Refresh now works but i cannot schedule refresh

[rchamorro]

I have uploaded a report and dataset that points to an on premises postgresql database that can be accessed from anywhere.

When I update the data with Power BI Desktop it works perfectly.

If I update the data using "Refresh now" in Power BI service it also works.

When I try to "Schedule refresh" in Power BI service it does not allow me to set it up and and says "Your data source can't bre refreshed because the credentials are invalid. Please update your credentials  and try again" and there is an (X) next to the data source that says "Invalid connection credentials". If I try to enter the credentials that I am 100% that are valid, it show an error and says that "The credentials proviedaded for the PostgreSQL source are invalid". 

I think I can fix it temporally using a gateway but this seems an error in Power BI service.

[v-jayw-msft]

Hi @rchamorro ,

What authentication method are you using?

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[rchamorro]

Hi @v-jayw-msft ,

I am using the "Basic" authentication method. It is the only option that appears.

Available authentication methods

Thanks.

[v-jayw-msft]

Hi @rchamorro ,

Strange, then I'd like to suggest you to contact the support for further analysis.

https://powerbi.microsoft.com/en-us/support/.

Best Regards,

Jay

Community Support Team _ Jay Wang

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