Full documentation and example for OData.Feed please

Question

The OData.Feed documentation is lacking.

There is no full description of the parameters. No indication is given, for instance, on how to form a query string? Is that just a normal OData query string, like "$filter=field eq value"? Or something else?

I also note that there could be, because i saw it in one sample on a forum, a "rowlimit" element in the options parameter (whose parameter description is lacking).

Endlessly trying combinations of what I think the exact syntax "should" or "could" be is very annoying and time-consuming.

Can we get a fully documented version, please, and include a sample or two, since the function is so complex?

-thanks in advance
-e

ericleigh007 · Answer

I appreciate the fact that PowerBI includes the docs.&nbsp; That was unknown to me, but then again, the information is identical to the "lacking" documenation on MSDN.&nbsp;I had found the web page and I was indicating it could use some work.&nbsp;The link included in your answer is not valid, as it doesn't lead the documentation page I already had found.&nbsp; Here's the one I had located and was commenting on:&nbsp;https://msdn.microsoft.com/en-us/library/mt260868.aspx&nbsp;&nbsp;This page contains a somehwat usable description of the fields in the record but includes no examples.&nbsp; Would it be difficultt to get someone to tweak the docs to include exampes, as just about every other PQFL page has?&nbsp; It liternally looks like the team ran out of budget and just stopped writing usable documenation. The record elements are not even in a table as in other documentation pages for PQFL functions.&nbsp;Specific information it takes for someone to understand the usage of OData.Feed is left out.&nbsp;Look, for example at the page for XML.Document:&nbsp;https://msdn.microsoft.com/en-us/library/mt260907.aspx&nbsp;There, we have complete descriptions of the usage, and we have examples. &nbsp; Developers can use good examples to start from a known good place when customizing usage of a function.&nbsp;One specific question would be (stating what I asked before) would be to have an explanation of and an example of the query element of the record.&nbsp; I've tried extracting a valid OData query URL portion, like "$top=2", and including that in several forms, and nothing seems to work differently.&nbsp;If the query string cannot include top=n, then what can it contain?&nbsp;You see how examples would help allow developers to understand the documentation.&nbsp;-thanks-e

ericleigh007 · Answer

I asked for an update to the doucmentation so that I and others would know how to use the OData.Feed command.

As such, only the "prefilter data for powerbi" may be responsive. I'll try that, but I have already done specific tests with OData.Feed, and comparing that with the same query in the browser, I find that OData.Feed works differently.

But I will log a speicfic problem report on that.

The original request to FIX the documentation so we know how to use the function, NOT tell us how OData is supposed to work.

-thanks

-e

v-qiuyu-msft · Answer

Hi ericleigh007,
&nbsp;
You can go&nbsp;through this article to know&nbsp;available OData query string options.
&nbsp;
On Power BI side, to get the data use Odata feed data source, for&nbsp;example Dynamics CRM, you can take a look at this article: Prefilter data for Power BI with OData URLs. The entered URL should follow the&nbsp;syntax of above OData URI.
&nbsp;
Maybe you are also&nbsp;interested&nbsp;in Filter a report with a URL query string parameter.
&nbsp;
Best Regards,Qiuyun Yu
&nbsp;
&nbsp;

mllopis · Answer

You can find documentation about OData.Feed (and all other M language functions) in MSDN. Here's the page for OData.Feed: https://msdn.microsoft.com/en-US/library/mt260868.aspx

Note that you can also find in-product documentation by just typing =OData.Feed (or any other function) in the Query Editor formula bar and hitting enter.

Thanks,
M.

Forum Discussion

Full documentation and example for OData.Feed please

4 Replies

Related content

Authenticating OData.Feed using Web API difficulty

Business Requirement Document Template

RSCustomDaxFilter Documentation

Data Agent Example Queries

Power BI Documentation