Forum Discussion
Can we use Datamart as a Data Warehouse ?
Hi Priya_Kulkarni - This can happen if the Datamart hasn't been successfully created or provisioned. Power BI might face issues while establishing the necessary infrastructure (like the Azure SQL Database behind the Datamart).
-
Service or Capacity Limits: If you're using a Power BI Premium Capacity, it could be running low on resources or has hit some limitations.
-
Temporary Service Outage: Power BI or related Azure services might have been experiencing temporary downtime or an outage when you tried to create the Datamart.
-
Schema Update Conflicts: There could be conflicts with the schema update, either due to issues with the data source or compatibility problems within the Datamart.
-
Sometimes these issues resolve themselves after a while, especially if it's related to temporary server-side issues.
-
Check Your Power BI Capacity: If you are using Power BI Premium or Premium Per User (PPU), check your capacity to ensure it has sufficient resources and isn't overloaded.
-
Check Permissions: Make sure that your account has the necessary permissions to create and manage Datamarts. This includes both Power BI permissions and access to the underlying Azure SQL resources.
Hope this information helps.
-
Super UserHi Priya_Kulkarni - Yes, Datamart in Power BI can be used as a Data Warehouse, particularly for self-service BI purposes. Datamarts store data in Azure SQL Database, making it highly scalable and enabling the integration of data from multiple sources, performing transformations, and facilitating reporting and analysis.
As for the storage costs, the data storage for Datamarts is included in the Power BI Premium license. This means that if you're using Power BI Premium (capacity or per user), there are no additional charges for storing the data in the Azure SQL Database linked to the Datamart. However, if you are on a non-Premium license, you would not have access to Datamarts, and any external Azure SQL Database storage would typically involve separate billing for the database itself.
Reference links:
Can you leverage Power BI Datamart as an Enterprise data warehouse? (saxon.ai)
Power BI: Pricing Plan | Microsoft Power Platform
Power BI Datamart - What is it and Why You Should Use it? - RADACAD
Thank you for the instant reply.
But getting this error while trying to create a Datamart.
We couldn't get your datamart's updated schemaDatamart '0cb42b3a-07fb-4cd6-aa0f-f5bf4f11f4c6' is not provisioned. This operation cannot execute.
Please try again later or contact support. If you contact support, please provide these details.
Hide details
Activity ID5c9144c1-dc2c-426a-b5ac-b9fda72b2342
Request IDa93c5e79-96bf-4eb8-a7d6-fbd5f0987349
Correlation ID44452df6-a3ce-6260-5def-2f1ac99f589d
Status code404
TimeSun Sep 29 2024 19:37:09 GMT+0530 (India Standard Time)
Service version13.0.24328.59
Client version2409.4.21074-train
Cluster URIhttps://wabi-india-west-redirect.analysis.windows.net/
Copy
Contact support
Any idea why this error occured?- rajendraongole1
Hi Priya_Kulkarni - This can happen if the Datamart hasn't been successfully created or provisioned. Power BI might face issues while establishing the necessary infrastructure (like the Azure SQL Database behind the Datamart).
-
Service or Capacity Limits: If you're using a Power BI Premium Capacity, it could be running low on resources or has hit some limitations.
-
Temporary Service Outage: Power BI or related Azure services might have been experiencing temporary downtime or an outage when you tried to create the Datamart.
-
Schema Update Conflicts: There could be conflicts with the schema update, either due to issues with the data source or compatibility problems within the Datamart.
-
Sometimes these issues resolve themselves after a while, especially if it's related to temporary server-side issues.
-
Check Your Power BI Capacity: If you are using Power BI Premium or Premium Per User (PPU), check your capacity to ensure it has sufficient resources and isn't overloaded.
-
Check Permissions: Make sure that your account has the necessary permissions to create and manage Datamarts. This includes both Power BI permissions and access to the underlying Azure SQL resources.
Hope this information helps.
-
