Datamart Capabilities

Hey smpa01 ,

here are my takes on your question, please be aware that I'm not MSFT (no matter how much I'm in love with Power BI and the whole data platform).

I change the order a little bit

A

Absolutely agree!

D
Unfortunately not, this is the reason why we turned the feature off. I'm not sure if a feature will be added of the course of time approaching GA that allows a more fine-grained control by adding security groups.

B
At the current moment you just can have look, but my assumption is that over the course of time DDL capabilities will be added, e.g., allowing you to create views on top of the tables and other you can create using DDL.

C

To be honest, I can't answer your question, as I'm currently testing in my private tenant, but will certainly test all this in the next couple of week. My current guess, every admin of the workspace is able to access the SQL DB, not sure about the ability to create dataflows to create tables.

E

I don't think so. At the current moment you can only create a base model, meaning no Calculation Groups, perspectives etc. Nevertheless, you can create a composite model based on the datamart dataset and add the features. I already tested that and it works as expected. I also like the idea of having one core dataset, and one or multiple composite models that use the core dataset as a foundation.

F

I have no idea 🙂

Hopefully, this helps you somehow.

Regards,

Tom