- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-24-2025
07:32 PM
Hi RichOB,
That error means the refresh account in the Power BI Service is hitting Business Central without a “default company,” so BC returns 404. Desktop works because your user likely has a default company set, but the cloud refresh identity does not.
Quick solution
- Put the company in the URL (don’t rely on “default”).
OData v4 web services:
https://api.businesscentral.dynamics.com/v2.0/<tenant>/<environment>/ODataV4/Company('Your%20Company%20Name')/<WebServiceName>
Notes: URL-encode spaces/commas, and if the name contains a single quote, escape it as two single quotes. Docs: Publish a Web Service.
Or switch to the Web API (recommended) and use company ID:
https://api.businesscentral.dynamics.com/v2.0/<tenant>/<environment>/api/v2.0/companies(<companyId>)/...
Get companyId from GET /api/v2.0/companies. Docs: GET companies. - Update dataset credentials in the Service (Settings > Datasets > Data source credentials). Use OAuth2 and sign in with a BC user that has access to that company. If you’re using an app/service principal, it must be granted access and you still need to include the company in the URL. Docs: Service-to-service authentication, and Power BI refresh notes: Refresh troubleshooting.
- Test the company list if you’re unsure of the exact name/ID:
OData v4: hit .../ODataV4/Company to see available companies.
Web API: hit .../api/v2.0/companies.
(The “default company cannot be found” guidance to add company=[name] or include Company in the path is a known fix discussed here: community thread with the exact error, plus MS docs above.)
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
521 Views