Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Datamart - SQL database capabilities

I am checking out the datamart preview feature. This is really exciting! But I have some questions..   Is it possible to provision a user(s) as member of the db_owner role? Can a user create store...
General Comment
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

Users can be configured as members of the db_owner role

There can be some limitations to creating.

 

Administrators can manage the following functions in the admin portal, which include writing data to the Datamart database

 

There is no more information about the features of the power app yet, but after all, it is a PREVIEW feature and may be introduced in a subsequent update or release with similar features.

 

For more details, you can read related document as below:

Administration of datamarts (preview) - Power BI | Microsoft Docs

Analyzing datamarts (preview) - Power BI | Microsoft Docs

 

Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for the reply -
- db_owner is not the same as "admin_user" - db_owner has full permissions within the database
- I am interested in DDL and DML, but not within the visual editor (I am using external SQL IDE to connect to SQL Server service)
- I saw about the auditing available in the admin center - but I believe this is just a report that indicates the quantity of operations being performed, by type? This doesn't explain how to perform INSERT or UPDATE

I can certainly appreciate this is in preview and we don't know the full details yet

 

Thanks for your response!