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
SriThiru
Helper I
Helper I

how to consume the query result from the power bi datamart in Power bi reports

I have created a new datamart by loading data from excel that contains transactional data

In Power BI Datamart, I created 2 queries that gives me monthly and yearly summary. I want to join these results with the main table either in the same datamart, or I sould be able to consume it in a fresh Power BI report from power bi descktop.

 

How can I do this?

Is it possible in power bi?

 

6 REPLIES 6
collinq
Super User
Super User

Hi @SriThiru ,

 

In Power BI Desktop, you select Datamart from the Data Hub option like this:

collinq_0-1674498620743.png

 

Or, you could go to "Get Data" select "more" and then select "Datamarts (Preview)" .

 

 




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




In Data Hub, the menu item you depicted is not enabled. In Data Mart, all but one of the buttons in the Data section of that toolbar are disabled... sucks.

Hi @collinq ,

 

Thanks for your reply, but I'm not looking for this.

By using the Datamarts connection in Power BI desktop I can only consume the dataflow table from the Power BI Datamart, but I want to consume the data from the queries I created in Power BI Datamart.

SriThiru_2-1674538971638.png

I tried both "Connect" and "Connect to SQL endpoint". Both options provide the same capability, unable to connect to the queries

SriThiru_1-1674538730647.png

 

Hey @SriThiru ,

 

I don't believe that you can open that in Desktop.  You can open that up in SSMS or Azure - since this is a SQL DQL and not something that can be consumed by Desktop.  I am basing that on this article: Analyzing datamarts (preview) - Power BI | Microsoft Learn

 




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




He was asking how to use the query he built within Data Mart. Regardless of desktop or web, how do you use that query in a visualization? The query is NOT based on SQL, but rather the Data Mart itself. I don't think this question was even understood, let alone answered. I am looking for the same thing and cannot find an answer anywhere.

Hi @RenegadeJr100 ,

 

If you want to use a query in a visualization, you can do so within the datamart tool (as of February update).  As I stated above, you cannot use that query in the Service or Desktop.

 




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.