Forum Discussion

ysalih's avatar
ysalih
Frequent Visitor
2 years ago
Solved

postgres.database.azure issue connecting with power bi

i cant connect power bi with postgres.database.azure :  error : Failed to update data source credentials: An error happened while reading data from the provider: 'Could not load file or assembly 'S...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ysalih ,

    Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

     

    Best Regards
    Community Support Team _ Rongtie

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

sergej_og's avatar
sergej_og
Super User
2 years ago

But you do need a connections for your gateway to be able to access your data source.
We had have similar situation. After creating gateway connection in Service and installing required driver for postgres it worked fine.

Regards.

bobbyiliev's avatar
bobbyiliev
Frequent Visitor
2 years ago

Don't you only need a gateway to access data sources that are on-premise? I believe that you don't need a gateway if your data source is running in the cloud. Eg, this is from the gateway docs:

> Do I need a gateway for cloud data sources, such as Azure SQL Database?
> No, services can generally connect to cloud data sources without a gateway. However, you might need a data gateway if your data sources are behind a firewall, require a VPN, or are on virtual networks.

So, as long as your data source is publically accessible, there should be no need to set up a gateway right?

To clarify, same as the author of the thread, this was working fine for me last week and it stopped working, a gateway was never set up.

Under my gateway options, I have the following message:

> Gateway and cloud connections: You don't need a gateway for this dataset, because all of its data sources are in the cloud.