Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper I
Helper I

OData V4 scheduled refresh in Power BI Report server error

In Power BI Report Server I'm trying to add a scheduled refresh with Data from Business Central using the Odata V4 feed.
Unfortunately, I am getting this message:

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: abf464e6-9697-433b-8469-79be61ed1476.)
I've tried all types of verification options (Key, OAuth2 etc)


Using the OData Feed in the Power BI desktop is no problem. All data is Refreshing and available. Also in the OData feed Url, the Company name is set.
I don't understand why it is asking for the "company=[name]" in the report server while it is already set and works in Power BI Desktop.

I look forward to your reply!

Helper I
Helper I

Hello again,

No, in Power BI report server desktop, I am using OData feed because it does support scheduled refresh when saving to the report server.

Does Dynamic 365 Business Central (on-premises) support scheduled refresh when saving to the report server?

Currently, I am using Power BI report server January 2021 version.

My OData Feed URL follow the below structure:‘Company%20Name’)/Tablename

I look forward to your reply!

Hi @imenmaiza , you probably have this already solved, but as I recently found myself facing the same error I'll post what worked out for me.


Our Business Central app was giving us the ODATAv4 URL like this too:'Company%20Name')/ 

This URL worked fine in Power BI Desktop but after uploading to Power BI service we were getting the same error message.


The only solution we've found so far is to change the '%20' back to a space ' ':'Company Name')/ 

This URL works in both Desktop and Service


I don't know if it's a known bug, but seems like it's been happening for quite some time




Hi Pablo, 

I'm facing the same issue and happened to come across your post. I've tried to change the %20 back to a space but it doesn't work for me. Did you change the data source in BI desktop? 

Hi, @imenmaiza 


I don’t have a suitable data source to test. In theory it should be possible, you can simply try it.

In addition, your report server version is indeed a bit old, not sure if it will affect it. If it doesn’t work, it’s still recommended to upgrade on a test machine and try it.


I also found something that needs to be set,you can check it:

OData web service must be enabled on the Business Central Server, and OData port opened in firewall. 

Enabling Power BI Integration With Business Central - Business Central | Microsoft Docs


Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

Community Support
Community Support

Hi, @imenmaiza 


Do you connect to the data source through the Business Central connector in the report server desktop?


And What's your report server version? It is recommended to use the latest version if possible:

Download Microsoft Power BI Report Server - May 2021 from Official Microsoft Download Center

Can you provide the code(hide privacy) for the data source connection part of the advanced editor in powerquery?


Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.