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

[Gopikrishna-J]

Hi Folks,

I believe, you can help me in fixing this error.

Recently, I found an article in our Power BI Community , with the help of  "OData connector with the report server API " , I'm trying to fetch all the report's connection string and data source related information  from power bi report server .

For your reference, here is the article link :

https://community.fabric.microsoft.com/t5/Report-Server/Get-all-connection-string-for-reports-from-p...

I've successfully implemented the code changes ( that's mentioned in that article )  and while i'm applying the change or while loading the data in Power Query Editor, it's throwing below error :

So, could you please help me in troubleshooting this issue .

Thanks in advance 🙂

[amitchandak]

@Gopikrishna-J , Increase timeout in advance options and try

Clear permission; provide credentials and try

if these do not help, check and log an issue- https://community.powerbi.com/t5/Issues/idb-p/Issues

[Gopikrishna-J]

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 🙂