Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

AdamSabourin

Postgre SQL Database refresh Error

Submitted by on ‎07-18-2022 09:28 AM

 

Hello!

Setting up a new dataflow. I connect to my data type of Postgresql.

I enter the connection, database name, and password, add it to the gateway and then I see my data in Power Query. Great!

I make ZERO power query steps, simply save and refresh. 

The refresh fails and gives this error:

Error: An error happened while reading data from the provider: 'We don't support CLR type 'NpgsqlTypes.NpgsqlTsVector'

Why can I see the data in the preview but not refresh? It's obviously connecting to it in preview?! 

Status: Investigating
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎07-18-2022 08:09 PM

Hi @AdamSabourin 

According to your error report, I searched for some errors related to dataflow, but there is no similar issue . Did you report the error caused by manual refresh or the error caused by scheduled refresh ? Maybe you can refer to the steps in the link below .

https://www.cdata.com/kb/tech/postgresql-powerbi-dataflows.rst 

 

Best Regards,
Community Support Team _ Ailsa Tao

AdamSabourin
Frequent Visitor
‎07-19-2022 05:23 AM

The error happens after the data flow has gone through its "save and close" checks/verifications and is on its initial refresh. It also occurs after manually initiated refresh. Thank you for investigating this.

Anonymous
Not applicable
‎08-03-2022 02:31 AM

Hi @AdamSabourin 

Can your dataflow refresh normally ?

 

Best Regards,
Community Support Team _ Ailsa Tao

AdamSabourin
Frequent Visitor
‎08-03-2022 03:24 PM

No I just tried again. Same issue:

PostgreSQL...

I enter the connection, database name, and password, add it to the gateway and then I see my data in Power Query. Great! It reads the data just fine in Power Query!

I make ZERO power query steps, simply save and refresh. 

The refresh fails and gives this error:

Error: An error happened while reading data from the provider: 'We don't support CLR type 'NpgsqlTypes.NpgsqlTsVector'

 

If I try to manually refresh the saved dataflow, the same thing...  


Error: An error happened while reading data from the provider: 'We don't support CLR type 'NpgsqlTypes.NpgsqlTsVector'.' Request ID: 7c5c2f7b-f1f0-8078-cc03-333f8226994e Activity ID: e3e93d98-3a9c-44ed-a322-2514e8038f5b

AdamSabourin
Frequent Visitor
‎08-09-2022 12:16 PM

OK. We finally figured it out. The PostgreSQL data source tables have parameter columns in them called "tsv". If you remove that column as a power query step and save, it will refresh! 

Idea Statuses