Forum Discussion

Gopikrishna-J's avatar
Gopikrishna-J
Frequent Visitor
2 years ago

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

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-power-bi-report/m-p/920392

 

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 🙂

 

Need Help
Tips and Tricks

2 Replies

    • Gopikrishna-J's avatar
      Gopikrishna-J
      Frequent Visitor
      2 years ago

      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 🙂