Forum Discussion

imenmaiza's avatar
imenmaiza
Icon for Helper II rankHelper II
4 years ago

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 r...
Odata feed
Refresh Schedule Error
PabloVR's avatar
PabloVR
Frequent Visitor
4 years ago

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: 

https://server.domain.com:port/instance-name/ODataV4/Company('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 ' ':

https://server.domain.com:port/instance-name/ODataV4/Company('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

 

Cheers

 

kaitlynnguyen's avatar
kaitlynnguyen
New Member
3 years ago

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?