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

[siredman]

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.

[lpunderscore]

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

[GilbertQ]

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?

[gschooling]

How can we use a Shared Query in datamart in a PBI report? It doesn't show up in the Get Data when I connect to the datamart. Only datamart tables show up.

[siredman]

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.