Forum Discussion
Dataflow Gateway brings wrong table
Hi there, I'm trying to set up an on premise gateway to refresh data to a dataflow. I need a gateway because, altought the data source is a cloud PostgreSQL, PBI ask for a gateway for refreshing ...
I found the reason.
It's not possible to do it. It's a limitation of dataflow. Period.
"Dataflows using gateway data sources do not support multiple credentials for the same data source"
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-features-limitations
You shouldn't need a gateway for cloud-based sources. Have you tried authenticating in the Data Source Credentials section of dataflow settings and not selecting a gateway?
Also, when you add a data source to the gateway and authenticate, you don't need to enter the credentials again authenticating from the dataflow.
On premises gateway is needed for PostgreSQL cloud data sources. It shuldn't, but it does.