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.
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!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |