Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
siredman
Microsoft Employee
Microsoft Employee

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.

3 REPLIES 3
lpunderscore
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.

GilbertQ
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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors