Forum Discussion
How can I create a table in Power BI Datamart using SSMS?
Hi HamidBee
Before you create a table in SSMS, please make sure you have CREATE TABLE permission in the database. You can check it using the below T-SQL statement, 1 in the output means, you have the permission to CREATE TABLE in the DemoDB database.
SELECT HAS_PERMS_BY_NAME ('DemoDB', 'DATABASE', 'CREATE TABLE');And you can click the link below and search for GRANT CREATE TABLE To, in order to grant this permission.
Giving and removing permissions in SQL Server (mssqltips.com)
How to create a table using SQL Server Management Studio (mssqltips.com)
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The answer I have gotten is that admin_user doesn't have the same rights as db_owner and is not allowed to be granted to create tables. But although a viewer that has the role public can be assigned the role db_owner I was not able to the last action because I did not have sufficient right to do this. So I am hoping someone replies an answer to this in the following link:
https://community.powerbi.com/t5/Service/Datamart-SQL-database-capabilities/m-p/2541428