I have created an custom web services(Odata) through Assisted setup in business central for connecting with power BI.
I got the following error message in powerBI,
When I tried to search in Brower the odata url its working,
Even though Query is filterded with some columns odata is returning all the columns, The columns that are not filtered in query are returned as errors as below,
Any idea how to resolve this?