Navision Odata (500) Internal Server Error

[Anonymous]

Hi

When connecting Power Bi to navision but I am getting the error message below.

This is a simple test version I created from the main report so it only connects to PostedSalesInvoices and PostedSalesInvoice lines. There are no relationships or other entities setup.

Strange thing is I am sure these connections were working and everything is fine when I first connect to the data source and it all works if the datasets are refreshed individually but always fails when doing both. Some times the refresh starts for both before it fails sometimes it fails straight away.

[Anonymous]

HI @Anonymous ,

For '500' error code, it is more related to request server. I'd like to suggest you to contact to datasource admin to confirm it or use fiddler to trace power bi requests.

What a HTTP 500 Internal Server Error Means and How You Can Fix It

Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.

Regards,

Xiaoxin Sheng