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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I am having the same error while trying to set up "auto refresh" in PowerBI Services yesterday, and still can't find a solution yet.

 

My PowerBI Desktop has no problem connecting and importing tables from this Azure Database. Also, after I clicked "Refresh" in PowerBI Desktop, the tables are still updated with latest data.

 

However, after publishing it to PowerBI Services, it shows the same error as yours while I try to edit the credentials.

 

--

Couple months ago, I also had trouble setting up "auto refresh", which I cannot recall what the errors are. I had to ask my Database Admin to set up permission in Azure Portal as instructed in this Microsoft document: https://learn.microsoft.com/en-us/power-bi/connect-data/service-admin-troubleshooting-scheduled-refresh-azure-sql-databases

 

I am asking him to double check this setting again, but he is on vacation for a week. You can try that and let me know if it works tho.

 

sergej_og's avatar
sergej_og
Super User
2 years ago

Your gateway is runnig on your local machine or on a separate VM?

Do you already have required driver installed on your gateway machine?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I never setup a gateway before to connect to this Database and to "auto refresh" my previous Reports in PowerBI Services.

     

    As I just checked in `Gateway and cloud connections`, I do not need to setup it. Is that right? sergej_og 

     

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