I have several datasources which I want to merge. DataMart seems to be able to do this by pulling in each datasource as a Table and then make a query with Combine -> Append Queries.How do I do something with the result of that query? It does not seem I can use that query as the input to anything else, I was expecting it would appear directly in the Report's Data view.
There is no way. This feature is pretty much useless until we can have those queries as views and use them with our tables.
The output from a datamart query is to be used in a report or can be consumed into another merge or append table?
What are you looking to do with the output from the datamart?
Proud to be a Super User!
Thanks for your reply.I would like to use the output of the query in my report, but in my report's Data tab I only see the raw tables.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.