Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Community,
The refresh of the data on the serivce fails, however a desktop refresh work without a problem. There is a failure message on the service:
By a trial and error approach I have figured out that an unpivot step in the query is causing this issue.
-> unpivot
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"Datum waarop de eerste keer uren zijn geboekt op deze activiteit", "FRH"}, {"De eerste confirmatiedatum", "FCD"}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Renamed Columns", {"Z_NA_QRY.Project Code", "Network", "Z_NA_QRY.WBS Element", "Network + Activity", "Activity", "Z_NA_QRY.Activity Code"}, "Attribute", "Value"),
#"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Columns",{{"Attribute", type text}, {"Value", type date}})
in
#"Changed Type"
Does anybody know why this unpivot step is causing a data mashup error when refreshing?
Solved! Go to Solution.
in some cases disabling time intelligence helps:
Hi @Kpham
Perhaps it's the #:Changed Type" step causing the problem because the dates are in US m/d/y format but the service is trying to change them to d/m/y?
Try changing the date using Locale.
Regards
Phil
Proud to be a Super User!
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
56 |
User | Count |
---|---|
99 | |
92 | |
84 | |
74 | |
66 |