DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server

Hi amitchandak ,

Many Thanks for looking on this issue,  actually, I'm using " OData Feed " as the data source , just I've used the URL to import the data  and I didn't see any advance option in this specific data source setting.

However, I tried the below method to increase the "OData query timeout"  , but still the issue remains same .

-------------------------------------------------------

How do I change the OData query timeout?
There is no centralized or report-central solution to increment the default value for timeout of 10 minutes to a higher value. In the Advanced Editor of Power BI the timeout value can be altered per OData query by appending , Timeout=#duration(days,hours,minutes,seconds) to the OData.Feed statement.

For example, to increment the timeout to 2 hours, the following query:

Bron = OData.Feed("https://bridge-online.cloud/3279/odata4/", null, [Implementation="2.0"]),
has to be changed into

Bron = OData.Feed("https://bridge-online.cloud/3279/odata4/", null, [Implementation="2.0", Timeout=#duration(0,4,0,0)]),

---------------------------------------------

Apart from this, I've noticed some behavior while it's loading the data in Power Query Editor - it's loading(downloading) the data till 1.7MB ( it displays 481 rows data ) and then it's throwing the above OLE DB or ODBC 500 internal server error.

Next point is, if we've less data and it is working fine without any errors , because I've tested this by connecting to PBIRS QA URL ( that have less reports in that environment ) .

So, I'm not sure whether it's a bug in the Power BI Desktop application (or) some issue within the report  (or) with the ODataFeed data source .

Could you please try to re-produce this at your end and see how it works for you  , kindly let me know.

Thank you once again 🙂