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
arpost
Advocate V
Advocate V

Should I connect to a datamart or a datamart's auto-generated dataset?

Greetings, all. Looking at adopting datamarts for our org but have a question. I see in PBI Desktop that we can connect to either the datamart OR the datamart's dataset:

arpost_0-1668536698796.png

I am curious to know if there's any difference and why a person might choose one over the other. I had HOPED that connecting to the datamart directly would let BI devs see the measure formulas in Desktop, but no joy.

 

UPDATE: To clarify, I mean what is the difference between/why would a person connect directly to the datamart as opposed to the auto-generated datamart's dataset? So if I had a datamart called "Datamart123", I could either connect directly to the datamart OR to the new dataset that was created called Datamart123. Is there any advantage/difference? 

 

I see with the datamart that it offers a SQL endpoint option.

1 ACCEPTED SOLUTION

Hi @arpost 

 

I believe you must see the following options when you choose a Datamart in Data hub window. 

vjingzhang_0-1668580115583.png

 

Based on my test, choosing the first option "Connect" has the same result as connecting to the auto-generated datamart's dataset directly. There is no difference according to my research. It just provides two entrances for users to access the dataset. 

 

If you choose the second option, it has the same result as connecting with the SQL endpoint connection string through Get data > SQL Server connector. 

 

Create reports using datamarts (preview) - Power BI | Microsoft Learn

 

Hope this helps. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

3 REPLIES 3
ribisht17
Super User
Super User

Please check Power BI Datamart Vs. Dataflow Vs. Dataset - RADACAD

 

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

Appreciate the reply and link, @ribisht17. My question is more about what is the difference between connecting to the datamart proper and connecting to the auto-generated dataset for it. I updated my question above to clarify.

Hi @arpost 

 

I believe you must see the following options when you choose a Datamart in Data hub window. 

vjingzhang_0-1668580115583.png

 

Based on my test, choosing the first option "Connect" has the same result as connecting to the auto-generated datamart's dataset directly. There is no difference according to my research. It just provides two entrances for users to access the dataset. 

 

If you choose the second option, it has the same result as connecting with the SQL endpoint connection string through Get data > SQL Server connector. 

 

Create reports using datamarts (preview) - Power BI | Microsoft Learn

 

Hope this helps. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.