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:
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.