Forum Discussion

JS_UNI4C's avatar
JS_UNI4C
Helper I
2 years ago
Solved

Issue connecting online... Odata Request Failed 404

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 refre...
  • Anonymous's avatar
    Anonymous
    2 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')/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.