I have been trying to call an oData source using a paginated query. It works like charm in Power BI Desktop, but I'm having some issues in the Service.
My query has a function, and as already mentioned in this forum it is disabled for loading.
However, I keep getting the error. Below all the facts. Many thanks in advance for your help.
The query works fine when I pass the parameters to it within the editor, but doesn't let me save.
Take a look at this blog for how to use the query option available in web.contents
Many thanks for your answer. I tried RelativePath as suggested in another post, but my query is Private, so I received an error message saying that RelativePath cannot be used with Private data sources. Also my query is oData, not Web.Contents.