Forum Discussion
Semantic Model Refresh Credentials Error
Hi again, now getting a new error here: Expression.Error: The environment "Add environment name here" does not exist
Looked in the Semantic Model, Settings, but can't see where this setting might be? Any ideas?
Resolver IIIAW-FP That new error is better news than it looks, because it means you're past the credentials problem and into a much smaller one.
"Add environment name here" isn't a value that came from your tenant. It's the literal placeholder text the Business Central app ships with, so what the error is really telling you is that the app's Environment parameter was never filled in. Power Query is dutifully trying to reach a Business Central environment actually named "Add environment name here", and of course no such environment exists. That's also why the credentials advice further up the thread didn't get you anywhere. Re-entering a password can't rescue a connection that's pointed at an environment which isn't there.
The reason you can't find it under the semantic model's Settings is that it isn't set there. These Business Central apps are template apps, and the parameters get entered in the app's own Connect step rather than on the model. Go to Apps in the left navigation pane, pick the Business Central app you installed, and choose Connect. You'll be prompted for Company Name and Environment, and that's the dialog whose defaults are still sitting there untouched.
Two things worth knowing before you fill it in, since they're the usual next stumble. For Environment, if nobody has created extra sandboxes for you, the value is Production. For Company Name, use the full name rather than the display name, which you'll find on the Companies page in Business Central under the Name field. Putting the display name in there instead gives you a different and fairly baffling error about a key not matching any rows in the table.
Which environments do you actually have, and does the Name on your Companies page match what you'd been entering?
Thank you and very helpful to understand. I'll give that a try.
Environment is Demo, and the company name is the same as the name on the companies page in Business Central so hopefully this will work now.
- v-abhinavmu
Community Support
Hi AW-FP,
Thanks for reaching out to the Microsoft fabric community. and thanks to PauReis & krishnakanth240 & Murtaza_Ghafoor for sharing valuable insights.
Thanks for confirming. Since the Environment is Demo and the Company Name matches the name in Business Central, please try updating these values and refreshing the semantic model again.
Hopefully, this resolves the issue. Please let us know how it goes.
Thank you all, for your help here.
I've got some traction with now being able to add the Environment and Company which has worked. I've resorted to deleting each app and reinstalling it as there does not seem to be an obvious way to update the app to the latest version.
Given this is a community thread, i'm grateful for the really positive offer of support here and thank you all for your input.