Semantic Model Refresh Credentials Error

[AW-FP]

Hi all,

I'm using a Power BI Pro licence. I'm trying to refresh the semantic models for the Business Central Power BI Native Apps and I get an error after sometime telling me the credentials for the D365BusinessCentral Source are invlaid. 

Tried looking here for any issues but I can't work out where to turn next. Fairly new users of BI so any help would be much appreciated. @PowerBI 

Thanks

[krishnakanth240]

Hi @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

[AW-FP]

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?

[PauReis]

@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?

[AW-FP]

@PauReis 

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 · Accepted solution]

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.

[AW-FP]

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. 

[PauReis]

@AW-FP Glad it's sorted. One thing on your last point, because it'll save you real time next round: you don't have to delete and reinstall to get a newer version.

Template apps have an in-place update. When a new version ships you either hit Get it on the update banner or in the notification centre, or find the app in AppSource again and choose Get it now, then pick "Update the workspace and the app". The bit that matters for you specifically is that overwriting keeps the configured parameters and authentication, so the Environment and Company values you just got working carry over instead of being re-entered for every app. It also never deletes reports or dashboards you've added yourself.

Two things worth expecting so it doesn't look like it's gone wrong. It drops back to sample data until the refresh after the update finishes, which is normal and documented rather than a sign the update failed. And if you originally installed these through a direct link rather than through AppSource, you won't get an update notification at all, which is documented behaviour and is probably why there seemed to be no obvious path to a newer version in the first place.

[AW-FP]

Thanks, will give that a go

[Murtaza_Ghafoor]

HI @AW-FP,

This is more likely authentication problem raher than  some issue with PowerBI
,

1. Re-enter the Business Central credentials in Semantic Model > Settings > Data source credentials.
2. Ensure the account has the required permissions in Business Central.
3. Verify that OAuth2 authentication is being used and sign in again if prompted.
4. If the password or MFA settings changed recently, update the credentials and try the refresh again.
5. If the issue persists, sharing the full error message would help identify the root cause.
   
   

If this helps, ✓ Mark as Kudos | Help Other