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.