Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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?

Status: Investigating

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

 

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

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