Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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