I have built an report where the source is odata.feed with an M function in the URI (to filter requierd data before downlaoding). For example a source request like
= OData.Feed("https://services.odata.org/northwind/northwind.svc/Customers?$filter=PostalCode ge '"
& Number.ToText(12209) &"'", null, [Implementation="2.0"])
In PBI Desktop this works. When it is published to web , you cannot update the data under settings/datasets and the PBI web side displays the following error
Query contains unsupported function. Function name: OData.Feed
As far as I have tested, the problem occurs with all M functions. By replacing Number.ToText(12209) with "12209" the PBI app has no problem and the update the request accurately.
Is there a way around this problem, or am I doing something wrong?
Go to Solution.
The problem ist solved if you follow the instructions ofhttps://blog.crossjoin.co.uk/2018/05/03/troubleshooting-data-refresh-performance-issues-with-odata-d...and replace the previous oData with an oData without the Entity and choose the entity and the filters afterwards.
Source = OData.Feed("https://api.parliament.uk/odata"),
#"Filtered Rows" =
each ([GroupName] = "Cabinet Office")
Then the M functions dont collide with PBI
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!