ODATA connection not refreshing in desktop, but refreshes in query and browser.

[Anonymous]

Hi all,

I'm having the following issue: I use an odata connection to retrieve info from Microsoft Dynamics Navision and use it in Power BI. Now, when I try to refresh my report, it gives an error message. The connection used to run perfectly and refresh all the time. The refresh in Power Query works, and the link can be used in a browser, and works if I provide credentials. 

The error: 

OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Index was outside the bounds of the array.).

Would really appreciate your help! Thank you in advance. 

[amitchandak]

@Anonymous , That is strange. Please refresh tables one by one in the report/data view and check if there any one table having different connection details.

Another way is open Home Tab -> Transform data -> Datasource setting and clear all related datasource permissions

Now when you refresh it will ask for details credentials again

[Anonymous]

Hello @amitchandak, thank you for your reply.

Unfortunately, this did not work. I also tried to limit the data that's loading by aplying a filter in the Odata URL, yet this still does not work.

Do you have any other ideas?