OData V4 scheduled refresh in Power BI Report server error

[imenmaiza]

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!

[imenmaiza]

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?
https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

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

My OData Feed URL follow the below structure:

https://demoserver.domain.com:7348/DynamicsNAV110/ODataV4/Company(‘Company%20Name’)/Tablename

I look forward to your reply!

[PabloVR]

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]

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? 

[v-janeyg-msft]

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

[v-janeyg-msft]

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