Data Factory
NewFeature Request: Enable Support for Dynamic Data Sources in Dataflow Gen 2
Francesco Lardieri on 21 May 2024 12:06:50
Issue Description:
When creating a Dataflow in Power Query editor using a dynamic data source, the process works smoothly within the editor but fails upon publishing.
Example Scenario:
- Data Source: OData
- I created a function with a parameter to query the OData source.
- I intend to invoke this function with a list of values for the parameter.
While refreshing the query in the editor, it executes without any issues. However, upon publishing, I receive an error message stating, "Dynamic Data Sources are not supported."
Also, this message is confusing because the query successfully runs within the editor.
- Comments (1)
RE: Feature Request: Enable Support for Dynamic Data Sources in Dataflow Gen 2
Agree, we need that feature! ref. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#refresh-and-dynamic-data-sources