Administration of datamarts
You can administer the use and settings for datamarts just like you can administer other aspects of Power BI. This article describes and explains how to administer your datamarts, and where to find the settings.
Enabling datamarts in the admin portal
Power BI administrators can enable or disable datamart creation for the entire organization or for specific security groups, using the setting found in the Power BI admin portal, as shown in the following image.
Keeping track of datamarts
In the Power BI admin portal, you can review a list of datamarts along with all other Power BI items in any workspace, as shown in the following image.
Existing Power BI admin APIs for getting workspace information work for datamarts as well, such as GetGroupsAsAdmin and the workspace scanner API. Such APIs enable you, as the Power BI service administrator, to retrieve datamarts metadata along with other Power BI item information, so you can monitor workspace usage and generate relevant reports.
Viewing audit logs and activity events
Power BI administrators can audit datamart operations from the Microsoft 365 Admin Center. Audit operations supported on datamarts are the following:
To get audit logs, complete the following steps:
Sign in to the Power BI admin portal as the administrator and navigate to Audit logs.
In the Audit logs section, select the button to go to Microsoft 365 Admin Center
Get audit events by applying search criteria.
Export audit logs and apply filter for datamart operations.
Using REST APIs for activity events
Administrators can export activity events on datamarts by using existing supported REST APIs. The following articles provide information about the APIs:
- Admin - Get Activity Events - REST API (Power BI Power BI REST APIs)
- Track user activities in Power BI
Capacity utilization and reporting
Datamart CPU usage is free during preview, including datamarts and queries on SQL endpoints of a datamart. Auto-generated dataset usage will be reported for throttling and auto-scaling. To avoid incurring costs during the preview period, consider using a Premium Per User (PPU) trial workspace.
Considerations and limitations
The following limitations should be considered when using datamarts:
Datamarts are only available in Premium Gen 2 workspaces.
Datamarts aren't currently supported in the following Power BI SKUs: A1/A2, EM1, and EM2.
Datamarts aren't available in workspaces that are bound to an Azure Data Lake Gen2 storage account.
Datamart extract, transform and load (ETL) operations can currently only run for up to 24 hours
Datamarts currently officially support data volumes of up to 100 GB.
Currently datamarts don’t support the currency data type, and such data types will be converted to float.
Data sources behind a VNET or using private links can't currently be used with datamarts; to work around this limitation you can use an on-premises data gateway.
Datamarts use port 1948 for connectivity to the SQL endpoint. Port 1433 needs to be open for datamarts to work.
Datamarts only support Microsoft Azure Active Directory (Azure AD) and do not support managed identities or service principals at this time.
Datamarts are currently not supported in Microsoft Teams.
Datamarts currently support the following SQL clients:
- Azure Data Studio
Datamarts aren't currently available in the following Azure regions:
- Sweden Central and South
- West India
- UAE Central
- Japan West
Datamarts are supported in all other Azure regions.
This article provided information about the administration of datamarts.
The following articles provide more information about datamarts and Power BI:
- Introduction to datamarts
- Understand datamarts
- Get started with datamarts
- Analyzing datamarts
- Create reports with datamarts
- Access control in datamarts
For more information about dataflows and transforming data, see the following articles:
Submit and view feedback for