Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I was receiving this error when converting DateTime to DateTimeZone using a Dataverse data source. I could not find any other posts here in the community regarding a work around or fix. I thought I would share my solution.
Scenario:
I simply needed to converty the dataverse field "createdon" from DateTime to DateTimeZone and ultimately into a Local TimeZone for the end user.
Steps:
1. Added a new column called "createdon_UTC" from "createdon". PowerQuery will create this as a text type.
2. Change the type to DateTimeZone on "createdon_UTC".
3. Added a new column called "createdon_Local" from "createdon_UTC". PowerQuery will create this as a text type.
4. Change the type to DateTimeZone on "createdon_Local".
Be sure to like this post if you've found it to be a solution for you.
Solved! Go to Solution.
@v-yalanwu-msft Power Query already had DateTime as the type for "createdon". Unfortunately, I needed to add timezone in order for the UTC to Eastern-US convesion for my users. Once I made that change, before my final solution posted here, Power Query would not apply the changes. This is when the error would appear.
Hi, @TheBishopEmpire ;
You could change type to Date/Time;
1. add custom column.
2.change type.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yalanwu-msft Power Query already had DateTime as the type for "createdon". Unfortunately, I needed to add timezone in order for the UTC to Eastern-US convesion for my users. Once I made that change, before my final solution posted here, Power Query would not apply the changes. This is when the error would appear.
User | Count |
---|---|
11 | |
8 | |
5 | |
5 | |
4 |
User | Count |
---|---|
17 | |
14 | |
8 | |
6 | |
6 |