Skip to main content

Data Factory

New

Feature Request: Enable Support for Dynamic Data Sources in Dataflow Gen 2

Vote (4) Share
Francesco Lardieri's profile image

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)
Francesco Lardieri's profile image Profile Picture

Igoris V. Wolt on 22 May 2024 12:38:51

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