Forum Discussion
Semantic Model Refresh Credentials Error
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.
Super UserHi AW-FP
Fix it by going to semantic model Settings - Data source credentials in Power BI service and choose Edit credentials and re-sign with your credentials with OAuth2. Ensure you have the right access privileges in workspace level before you do above steps, if not check with your Admin for the access
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-permissions
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-manage-access-permissions
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios
Thanks, will give that a go
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?
PauReisResolver II
AW-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?