I am working on a .pbit that was created by an employee who no longer works with the company. When I try to refresh the data the report stalls out on a particular custom measure field. I would like to be able to fix that custom field or delete it so I can try refreshing without it but if I try to do almost anything in this report, including deleting the field, renaming the field, editing the DAX for the field, applying changes to the report, deleting a *different* field, anything at all, I get the same error:
"Something went wrong
Cannot construct data type date, some of the arguments have values which are not valid.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. The current operation was cancelled because another operation in the transaction failed."
The (obviously incomplete) DAX for that custom measure is "
StartDate(bucket) = DATE(YEAR('DeviceEvent'[StartDate]), MONTH('DeviceEvent'[StartDate]), DAY('DeviceEvent'[StartDate])) + TIME(HOUR(DeviceEvent[ti,0,0)))" and throws an error reading "The following syntax error occurred during parsing: Invalid token, Line 1, Offset 125, [ti,0,0))))."
How can I bypass this error that is locing this .pbit down entirely?
on:
URGENT!! Paginated Report not loading on Mozilla F...
mattlee
on:
“Add Value” in Textbox Not Visible in Dark Theme
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
on:
Fix the Date function in DAX