Forum Discussion

segev200's avatar
segev200
Frequent Visitor
3 years ago

Datamart - data load and storage

Hi, quick question, can datamart be used for data storage? I would like to load new batch of data every week in a way so new data will be added to the old one, but I don't want to keep old data sources. Obviously it can be easily done with SQL, but I'm wondering if datamarts have this option of storing data after being disconnected from data source.

 

Thanks

Dataflow

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi segev200 ,

    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.

    Once data is loaded into a datamart, you can additionally define relationships and policies for business intelligence and analysis. Datamarts automatically generate a dataset or semantic model, which can be used to create Power BI reports and dashboards. You can also query a datamart using a T-SQL endpoint or using a visual experience.

    For more details, you can read related document: Introduction to datamarts - Power BI | Microsoft Learn , Understand datamarts (preview) - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • segev200's avatar
      segev200
      Frequent Visitor
      3 years ago

      Thank you, but that was not my question. I'm basicaly wondering if I can save data in Datamart if I desconnect data source. When I work with SQL DB I can "dump" there data from different load files and this data will be stored there even if I delete load files, so I am trying to understand if datamart has same functionality?