Forum Discussion

JayJay11's avatar
JayJay11
Icon for Resolver II rankResolver II
2 years ago
Solved

Dynamic data sources are not supported - What is the workaorund?

Hello all,   I am trying to do the following simple query:     let Source = OData.Feed("https://myredacted-api.s4hana.cloud.sap/sap/opu/odata/sap/API_GLACCOUNTLINEITEM/GLAccountLineItem?$se...
Dataflows
  • miguel's avatar
    miguel
    2 years ago

    Hi,

    The alternative for your case is to use the root url of your OData service and leverage the query folding capabilities of the service and the connector. In that sense, you won't be passing the vDateFrom as part of the url for the data source (which is the thing thats blocking you at the moment), but rather you can use it as an argument for a filter in your PostingDate column. If you prefer the M code route, it's gonna be like using a Table.SelectRows and passing the vDateFrom as the argument to it.

     

    It is not recommended to pass all the filter arguments to the url. Especially if you know that your data source supports query folding.

     

    You can read more about query evaluation in Power Query using the link below:

    https://learn.microsoft.com/en-us/power-query/query-folding-basics 

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi JayJay11 

 

Thanks for using Microsoft Fabric Community. 

Apologies for the inconvenience.
As I understand that when you are trying to publish the dataflow Gen2 while query references another query you are getting an error dynamic data sources are not supported.

Appreciate if you could share the idea in our Idea Forum . Idea in this forum would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

 

Hope this helps. Please let me know if you have any further queries.

 

Thanks.