Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 stored procedures, schemas, tables, users, etc.?
Can we write data directly to datamart db?
Can datamart be used as target for power app insert/update operations?
I have done the same as what have been written here - assigned a user the role viewer (that has the role public in the datbase) in my workspace and then tried to add the role public to the db_owner role. I wrote:
EXEC sp_addrolemember 'db_owner', 'public'
The answer I get is: Cannot alter the role 'db_owner', because it does not exist or you do not have permission.
Why does this happen? db_owner exist in my database and I am an admin_user.
Hi @cmeu ,
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.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
20 | |
16 | |
16 | |
15 |
User | Count |
---|---|
34 | |
18 | |
17 | |
17 | |
17 |