Bij het ophalen van data in Power BI kan een melding verschijnen zoals:
Microsoft.Mashup.Engine1.Library.Resources.HttpResource:
Request failed:
OData Version: 3 and 4, Error:
The remote server returned an error:
(500) Internal Server Error.
(The selected database segment ‘acme-exact-online’ must exist for the delegating organization ‘ACME B.V.’.
Check if a database with this segment exists for the delegating organization.
Perhaps the database exists in your original organization instead.
In that case, switch back to your original organization or use an Invantive Cloud account within your original organization to retrieve data from the database.
(itgenscr754, 2023e09e-f142-4794-b076-cc916e73278f))
… dito for version 3 and 4
The error code itgenscr754 indicates that the database with the value acme-exact-online at Bridge Online URL Segment does not exist in the Invantive Cloud screen “Databases” in the organization accessed (direclty or through delegation).
Recommendation when NOT using delegation
If the user does not use delegation, the recommendations are:
- Check the “Databases” screen on Invantive Cloud if the Invantive Cloud user used can see this database, or a database similar in name that is actually meant.
- If the desired database is found, verify that the value at Bridge Online URL matches the URL specified by the report. In consultation with the main Invantive Cloud user(s), modify the URL by changing the “Bridge Online URL segment”.
- Consider using a Power BI report that is dynamic in terms of used URL so that it is easy to switch between multiple Invantive Cloud databases of different organizations. This can be done for example with Power BI Parameters as described in Use Power BI parameters with Invantive Bridge Online.
- Verify that the correct login data is used by Power BI (adjust the login data and/or scope if necessary via “Data Source Settings” in “Transform Data” dropdown menu).
Recommendations when using delegation
If the user uses delegation, the recommendations are:
- Do not use delegation for structural refresh such as through PowerBI.com or other production purposes. Delegation is only for assistance and not for production purposes.
- Use a service account for structural downloading using, for example, the Power BI Service. Such a service user account cannot switch between organizations, as through delegations (see Manage users on Invantive Cloud) and is shielded from many regular user tasks, increasing the security level.
- Check the “Databases” screen on Invantive Cloud if the Invantive Cloud user used can see this database, or a database similar in name that is actually meant.
- Switch to another organization via delegation or switch back to own organization.
- Consider using a Power BI report that is dynamic in terms of used URL so that it is easy to switch between multiple Invantive Cloud databases of different organizations. This can be done for example with Power BI Parameters as described in Use Power BI parameters with Invantive Bridge Online.