Failed to save modifications to the server. The end of the input was reached

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)).

 

timahenning2_0-1701872116480.png

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.

 

timahenning2_1-1701872236787.png

 

I refreshed the data and the report was fine.  What happened?

Investigating
Comments
avatar user
Anonymous
Not applicable

Hi  @timahenning2 

You can troubleshoot the issues you're having inside model.bim by following the content of the 2 links below.

https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-overview#model-authoring

https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-overview#considerations-and-l...

 

Best Regards,
Community Support Team _ Ailsa Tao