Share via

VS solution cannot open .bim value of '311' is not valid

Tina Douglass 1 Reputation point
2021-04-26T14:52:40.99+00:00

I have a VS solution tabular model .bim that has been created and deployed to our production and development environment. The data is being processed nightly through Azure. HOwever, I am now not able to open the .bim in the solution. I receive the error Value of '311' is not valid for 'Value'. 'Value' should be between 'minimum' and 'maximum'. Parameter name 'Value'.

I am not sure what this is referencing to. I have viewed the code. We do have columns with column name of Value but they wouldn't be referring to this type of value '311'. Does anyone have any suggestions on how to problem solve this? I have found a site that provides steps for importing what was deployed in production and recreating a solution, but i would rather not do that. We do not this versioned yet and the only copy is my local drive and what I deployed.

Thoughts/help?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,248 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-04-28T03:04:45.587+00:00

    You could try delete setting file see if it works, as this worked for others. Try deleting the Model.bim_username.settings or .layout file. Notice they might be hidden in the project folder. The method was mention in this thread.

    Troubleshooting this kind of message could be quite hard. You could try search through the code see if there is "311" string exists. And try deal with it.(Backup well before the operation!)

    Last choice is to reconstruct and deploy the project, that we are trying to avoid.

    1 person found this answer helpful.