Forum Discussion

Priya_Kulkarni's avatar
Priya_Kulkarni
Frequent Visitor
2 years ago
Solved

Can we use Datamart as a Data Warehouse ?

Can we use Datamart as a Data Warehouse? If yes Data will be stored on Azure SQL Database. Is this storage charges included in Power BI license or need to pay additional amount?
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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.

     

     

Priya_Kulkarni's avatar
Priya_Kulkarni
Frequent Visitor
2 years ago

Thank you for the instant reply.

But getting this error while trying to create a Datamart.


We couldn't get your datamart's updated schema

Datamart '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's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

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.