Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Desktop Database Connection/Refresh Error

Hi all.   I have a dashboard I have developed with some metrics that sits on top of postgresql, but for some reason will not refresh. I looked around and relized that the credentials for the databa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

I'd like to suggest you use edit permission credentials and try again.

 

Power bi not contains any write back features, but sometime you had to use edit permission credentials to get fully support.

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    Sorry I wasn't clear. So the user has a createDB role but has all permissions granted to that user ie (insert,read,write,tuncate,..ect). 

     

    Should I define a user with superuser access, that seems like it shouldn't be necessary? I created a new superuser with all permissions and new login information, but power bi can not authenticate the user...why?

     

    Cheers.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Anonymous,

       

      I'd like to suggest you to create new pbix file to test new credentials, it seems like logged credentials conflict with new one.

      Please clean up these cached credentials and test with new pbix file.

       

      Regards,

      Xiaoxin Sheng