Here is a little information on what Power BI Datamart is:
"Datamarts help bridge the gap between business users and IT. Datamarts are self-service analytics solutions, enabling users to store and explore data that is loaded in a fully managed database. Datamarts provide a simple and optionally no-code experience to ingest data from different data sources, extract transform and load (ETL) the data using Power Query, then load it into an Azure SQL database that's fully managed and requires no tuning or optimization."
I connected to the Datamart via SSMS using a SQL endpoint.
Hi. I tried running the query:
SELECT HAS_PERMS_BY_NAME ('DemoDB', 'DATABASE', 'CREATE TABLE');
I received the following:
I guess '0' means that I do not have permission so I tried to grant permission by using this query:
GRANT CREATE TABLE TO admin_user;
but I received the following:
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
One thing I did notice is that the tables appear under 'System Views':
I'm really not sure what to do. Any help would be greatly appreciated.