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 sourc...
Dataflow
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?