Forum Discussion
alexTaran
2 years agoFrequent Visitor
Postgre "We do not support CLR type 'Microsoft.Mashup.Engine1.Runtime.ValueException'" Error #powerB
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 fie...
- 2 years ago
Hi, everything works but you should trasform data by SELECT CAST.
In my case it was:
Greg_Deckler
2 years agoCommunity Champion
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.
- alexTaran2 years agoFrequent Visitor
hi, Greg,
Is there any manuals how to do it by using R?