Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cannot connect Power Bi Service to PostgreSQL hosted in Azure

Suddenly we started to face this issue, we are unable to connect Power Bi Service directly to PostgreSQL Database hosted in Azure. we started seeing this error: An exception occurred: DataSource.Mi...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Sorry for my lose. We have submitted to internal icm 311546402 , engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.

     

    Best Regards,
    Community Support Team _ Caitlyn

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Just got an update from the support team that they have fixed the issue, which I can confirm seeing my datafloiws running again. 

  • AdamSabourin's avatar
    AdamSabourin
    Frequent Visitor
    4 years ago

    I'm getting an issue still. In power query i see the data and can perform cleaning steps on PostreSQL data but upon save and close I get this on refreshes:

     

    "Error: An error happened while reading data from the provider: 'We don't support CLR type 'NpgsqlTypes.NpgsqlTsVector'.' Request ID: 3249c2a8-7b04-89f6-9e2d-38e0db0838ec Activity ID: 92c2b05f-2e76-4a2b-ad4c-ceb9116171ad"