Showing results for 
Search instead for 
Did you mean: 

What can I do with the results of a Query in a DataMart?

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.

New Member

There is no way. This feature is pretty much useless until we can have those queries as views and use them with our tables.

Super User
Super User

Hi @siredman 


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?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

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.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors