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

[timahenning2]

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 column name and it made its way into my model.  Researching a little I found the Power BI Rest API export to CSV inserts a trailing space for this one field.

CSV

REST API Call

The fix:

Open the BIM model in VS Code and remove the space.

This should be fixed.

Thanks,

Tim 

[timahenning2]

One solution is to trim the column spaces in Power Query.