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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
smpa01
Super User
Super User

Datamart Capabilities

Datamart is awesome, to say the least, and I intend to take this on a test drive and eventually convert it into a prod element. I have a massive prod use case for which there is no better solution than datamart.

Before I take this on a spin, I am looking for a few answers.

A. For data ingestion into datamart - Do we have Incremental Refresh? (If not currently available, is it on cards?)  It is currently available and this is simply mindblowing.

B.  What is the purpose of being able to write SQL queries on the SQL console currently available in DM?

Are we able to write SQL queries and ingest the transformed table back into the same DM?

As far as my understanding, we can access the Azure SQL server (the DM is connected to) and write fully qualified SQL queries and create dataflow/dataset as we please.

But I simply have not understood what can we do with the SQL query written on the SQL console in DM. What can we do with the query result?

smpa01_0-1654100357475.png

C. Who can access the SQL sever that each DM is connected to? Are all the PBI admins of the workspace can access the SQL server? If yes, how can I restrict access of admins to the server and prevent the inefficient SQL writers off that particular server?

D. Is it possible to pick and choose POWER BI admins (I don't want any other admins to mess around with prod datamart's query ingestion) to provide access to a particular DM?

E. I have also seen that DM has data modelling capacity- does it mean that we can access the same db from a SSAS server (if not now, later- that would be simply mindblowing)?

F. How do I delete added tables from DM? I am currently getting this error when I try delete one of the previously added tables from DM. How can I seamlessly do it without wreaking any havoc? I don't want to find myself in a position where I need to delete a DM in order to delete a particular table within a DM

 

DatamartUserWorkloadError
ErrorMessage
User workload error
Param0
Capacity operation failed with error code DmsObservableUniverseHasChanged

 

 

Thank you in advance.

@TomMartens 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
2 REPLIES 2
smpa01
Super User
Super User

Thanks @TomMartens 

D. Is it possible to pick and choose POWER BI admins (I don't want any other admins to mess around with prod datamart's query ingestion) to provide access to a particular DM?

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.

But I saw that roles can be defined for RLS. Does it not restict access of other admins?

 

 

 

Can someone from Microsoft please shed some light on

F. How do I delete added tables from DM?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors