F_Lardieri's avatar
F_Lardieri
New Member
2 years ago
Status:
Needs Votes

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

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.


2 Comments

  • Agree, we need that feature! ref. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#refresh-and-dynamic-data-sources

Recent ideas