Using PBIP project. October 2023 version.
I could not open my client's report. I received this error message:
Stack Trace Message:
Failed to save modifications to the server. Error returned: 'The end of the input was reached.
The following system error occurred: Out of present range.
Datatype conversion failed for [Table: 'powerbi vw_resident_care_agg_by_care_level_shift', Column: 'effective_date', Value: '20230425']. (powerbi vw resident care agg by care level shift (76); effective date (290)).
I had to open Tabular Editor and delete a hidden date heirarchy table that had a relationship to get the model in a state to open again.
I refreshed the data and the report was fine. What happened?
Comments
- joakims on: "The import PowerPlatform.Dataflows matches no exp...
-
NikNithiy
on:
URGENT!! Paginated Report not loading on Mozilla F...
- duarte on: Unable to sort months in PowerBI
-
mattlee
on:
“Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on:
Fix the Date function in DAX
-
Stinkys
on:
Cannot login to community site
-
reubwork
on:
May 25 update for Snowflake Connector v2 has broke...