Issue connecting online... Odata Request Failed 404

[JS_UNI4C]

Hi all, 

I created a dashboard via Power BI desktop and have been publishing it manually when making changes and also refreshing data to get user feedback. Today I tried to actually set the refresh schedule online since the dashboard is basically complete and I want it to go live for all users but I am getting the following error and have absolutely no clue how to fix it since I don't get this error or issue when using Power BI desktop. 

Any help would be highly appreciated. I tried google but sadly this specific issue doesn't appear to be one others have experienced.

"OData: Request failed (404): The remote server returned an error: (404) Not Found. (Cannot process the request because the default company cannot be found. You can specify a default company in the service configuration file, or specify one for each tenant, or you can add a query string in the form of "company=[name]". You can see the available companies by accessing the default OData web service, Company. For more information, see "OData Web Services" in Help. CorrelationId: 02e279b9-ebb7-4d0a-9e99-1e61dac48127.)"

The above message is what I get after I authenticate with my organisation details. 

Any ideas how to fix this???

[Anonymous · Accepted solution]

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')/PageName

You 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.

[JS_UNI4C]

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? 

[Anonymous]

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

[JS_UNI4C]

Hi, 

Many thanks for the response. This is super technical so I'm going to send your message to our internal BC expert and hopefully he will know how to sort it out. 

Once again, many many thanks for your response. Glad this isn't so complicated. 

Kind regards,

Jason