Forum Discussion
Convert DateTimeOffset to DateTime
As the very worst case I would likely do something similar but I would not want to do that because it will not be just key-value pairs, it has to be something smarter which will take into account Day Light Savings Time for specific timezone which eventually means that there are multiple offsets per any time zone, so, that sounds like not just lookup but lookup + logic and if I don't implement that logic my reports would be wrong at least 2 times per year.
I could not beleive that such basic functionality is not available in Power BI, these are just fundamentals for any live report (which Power BI claims to be) to have true support for time zones (Offset can be determined by knowing a time zone but but time zone can not be determined if just offset is known because there are multiple offsets per any time zone).
Is that possible to use .NET language while shaping a data for Power BI ?
Not to my knowledge, but you can use R in Power BI.
But I definitely recommend that you post this question at stackoverflow. There the MS guys are answering the PQ questions. They might know more about it.
I posted in that forum but there are no replies.
So, to close on this: I ended up doing my conversations in SQL due to "Power" BI / "Power" Query limitations
That's a pity.
But as Microsoft is adding new features month by month with often stem from users requests: How about posting the missing functions in the Ideas section here: https://ideas.powerbi.com/forums/265200-power-bi?