Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
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.
Hi @v-jayw-msft ,
I am using the "Basic" authentication method. It is the only option that appears.
Thanks.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.