Forum Discussion

timahenning2's avatar
timahenning2
Helper II
2 years ago

PBIP - Getting 'Unable to open document' error when I try to open project

I worked on my project last night saved and closed.  The next day I tried to open the project and received this error prompt: It seems like there is a trailing space introduced into a colu...
General Comment
arrows20's avatar
arrows20
Regular Visitor
2 years ago

For others facing this issue, worked on small Tabular Editor 2 script to loop through all measures and removes last character if it happens to be whitespace. Saved me a lot of time if anyone needs it

 

foreach(var measure in Model.AllMeasures)
{
    // Check if the measure name ends with a whitespace
    if (measure.Name.EndsWith(" "))
    {
        // Remove the trailing whitespace and update the measure name
        measure.Name = measure.Name.TrimEnd();
    }
}