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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Connecting to PowerBI Datamart

Hi

I started to check the PowerBI Datamart.

I was wondering if I can connect from Power BI Desktop to PowerBI datamart?

 

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @Anonymous ,

 

when you create a Power BI datamart, there is also a dataset created with the same name as the datamart.

With Power BI desktop you can connect to that dataset with the connector for Power BI datasets:

selimovd_0-1654712979175.png

 

or:

selimovd_1-1654713064288.png

 

 

From then on it's identical to a connection to any other Power BI dataset.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

View solution in original post

4 REPLIES 4
Syndicate_Admin
Administrator
Administrator

For me it is more interesting to connect to the datamart using the sql server connector.
the name of the server is the connection string that appears here

facabeza_0-1654903349569.png

that way you will be able to take advantage of any of the datamart tables and add them to your model.

If you connect to the dataset you can only use data from that dataset and that can be frustrating.
I hope you serve the recommendation!
Best regards

f

Anonymous
Not applicable

Thanks a lot @selimovd 

otravers
Community Champion
Community Champion

You didn't specify which part of the datamart you wanted to connect to. You can either connect to the Direct Query dataset as explained by @selimovd above, or to the SQL database via its connection string.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals
selimovd
Super User
Super User

Hey @Anonymous ,

 

when you create a Power BI datamart, there is also a dataset created with the same name as the datamart.

With Power BI desktop you can connect to that dataset with the connector for Power BI datasets:

selimovd_0-1654712979175.png

 

or:

selimovd_1-1654713064288.png

 

 

From then on it's identical to a connection to any other Power BI dataset.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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