Forum Discussion
Query Power BI Service dataset into Dataflow
If you really must, use the Analysis Services connector with a custom DAX query.
However this is a design red flag. A dataflow should get its data from the original data source, not from a secondary source like a semantic model.
Rumor has it that datamarts are on the way out (in favor of the new Fabric offerings). Personally I never liked them as they were just glorified dataflows with an Azure SQL instance slapped on in front. A solution looking for a problem (in my opinon).
Glad you got it working.
Interesting. As I have been exploring Datamart, I actually like the potential, particularly with this capability to combine different ad hoc data with data/measures from our standard semantic model dataset. The SQL component is a great feature but the shortcoming of it was that it couldn't be used to create new tables or views that could then be incorporated into the Datamart model - I prefer to do transformations in SQL rather than M/Power Query. Limiting SQL to only data exploration seems like a half-way solution.
Overall, I wish Microsoft would build capabilities for the long-run and stick with them rather than constantly introducing/removing new features - it is great to add new features and tools, but it doesn't help if the end result is that it becomes impossible to build our internal processes and reports off of them because we don't know which features/tools are permanent and which will be removed next year.