Datamart - data load and storage

[segev200]

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

[Anonymous]

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]

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?