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.
Hi, community,
need help how to solve error issue during connection to postgre db from dataflow (or desktop - not matter).
Connection is ok but when I try to transform data, I see errors in fields where text or whole numbers should be (see picture 1).
When I try to see details, there is a message from pbi:
" 'We do not support CLR type 'Microsoft.Mashup.Engine1.Runtime.ValueException'"
(see pic2)
Any ideas how to couple with this error?
I have found a similar topic but there is no decision of this trouble.
Thanks in advance
Solved! Go to Solution.
Hi, everything works but you should trasform data by SELECT CAST.
In my case it was:
Hi, everything works but you should trasform data by SELECT CAST.
In my case it was:
@alexTaran Dictionary/composite types are not supported in Power BI: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
You *might* be able to do something by using Python/R to connect to the Postgres server and doing some fancy conversion stuff.
hi, Greg,
Is there any manuals how to do it by using R?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |