Forum Discussion
Issue connecting online... Odata Request Failed 404
- Anonymous2 years ago
Hi JS_UNI4C
I understand that you are having trouble refreshing your Power BI dashboard online.
According to the error message you shared, you need to specify a default company name for your OData connection. This is because Power BI Online cannot automatically detect the company name from the OData URL like Power BI Desktop can.You can try the following:
You can add a query string to the end of your OData URL in the form of company=[name], where [name] is the name of your company in Business Central. For example, if your company name is “Royale - Live”, your OData URL would look something like this:
https://api.businesscentral.dynamics.com/v2.0/xxx/Production/ODataV4/Company('Royale%20-%20Live')/PageNameYou can specify a default company name in the service configuration file in Business Central. This file is located in the Service folder of the Business Central Server installation. You can edit the file using a text editor and add the following line under the <appSettings> section: <add key="DefaultCompany" value="[name]" />, where [name] is your company name in Business Central .
You can refer to this article:
Solved: (404) Not found error Company name - Business cent... - Microsoft Fabric Community
You can specify a default company name for each tenant in Business Central. This can be accomplished by using the Set-NAVServerConfiguration cmdlet in PowerShell.
You can refer to this article:
OData V4 issue in powerBI online - Microsoft Q&A
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry, if I may ask one more question Anonymous . Would this URL be updated in the Power BI desktop app before the report is published or is the URL updated online in the Power BI cloud app?
Hi JS_UNI4C
You can use the OData connector in the Power BI desktop app to connect to the OData service and enter the URL address you want.
You can also use the OData connector in the Power BI cloud application to load the data and enter the URL address you want.
You can update your URL address in any application as long as you reload the data.
If you want to update your URL address in the Power BI cloud app, you need to first publish your report in the Power BI desktop app, and then edit your dataset settings in the Power BI cloud app to modify your URL address and refresh the data.
Regards,
Nono Chen