Microsoft Idea · OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

5e0f5b0b 39cf-ea11-a812-000d3a8faea9 on 26 Jul 2020 12:14:50

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

Please can we get this issue sorted as it is very hard to push reports out to many customers when the url has to be hardcoded in order to get around this problem

c9a40d63 fdff-4e92-a38a-22ca9f20070c on 06 Jul 2020 00:05:45

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

This is essential for efficient data refreshed using the OData.Feed connector.

I can create a dynamic query URL to filter by a date that is generated in PowerQuery and it will refresh perfectly in Power BI Desktop. However when I publish to the Power BI Service I get the dreaded "Query contains unsupported function. Function name: OData.Feed" error.

The workaround of using a static query URL and then filtering in Power Query is much less performant.

343d748a ec7d-444d-915c-7af47b30f2bb on 05 Jul 2020 23:59:47

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

So painful not being able to script dynamic URLs...
I can't understand how it could be so complicated to fix this and why it is not already done.

757088df ece8-483b-829d-53d5d00342aa on 05 Jul 2020 23:19:49

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

Is there an interim workaround for crawling project sites to extract list items yet?

abba35d1 1de5-4617-8c8b-c97ff098c557 on 05 Jul 2020 23:10:22

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

Essential to be able to do this. In our case we use a parameter to accept a user login which is used in the query

fd1059b3 dc85-4eb9-ac07-ef952d39ce7e on 05 Jul 2020 22:26:02

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

With the constraints of the Project Online data model, the ability to have a dynamic query to retrieve data from project sites is critical. It works in other tools and should really be the standard functionality.

e431266a 98ee-4713-bb7f-e0d9528ad5f3 on 05 Jul 2020 22:19:20

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

I have problem similiar to Julian. I also do user PowerBI OData queries. A have a portfolio report for projects where I access PWA (project online) and Sharepoint-projectrooms (lists within each projectrom) to accumulate and generate a portefolio report. Works 100% on PowerBI Desktop, but refresh fails on powerbi.com. I need the OData query to be dynamic and build the OData query string based on parameters before accessing the datasource.

ad675ab8 4545-4def-90b2-0ee2659f745a on 05 Jul 2020 22:18:59

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

Hope this gets solved soon as it is really a pain to rewrite all URLs when moving from TEST to PRODUCTION environments

9bc701a7 ed3b-4220-a528-4853cd9b1e3a on 05 Jul 2020 22:03:40

RE: OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

We have a very similar request:
We are extensively using Power BI's OData feature to retrieve data from Microsoft Dynamics NAV. Since a typical report needs to retrieve data from multiple data source it is time-consuming to change each OData.Feed () call when we are moving a report to another customer. We tried to build up the OData.Feed () from another query called ODataBasePath in order to create a single reference point where we can change the OData-connection. It could look like this in all queries:
Source = OData.Feed(ODataBasePath & “ServiceName”)
In Excel and Power BI Desktop this is working fine. However the scheduled refresh on PowerBI.com seems to be unable to handle this dynamic OData.Feed. It is giving this error message that the scheduled refresh is currently not available for this data source.
It would be of great help for our standard reports.