Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper III
Helper III

PowerBI datamart history data and access to SQL DB?


I see the new introduction of datamarts as a great simple step for us who needs a step between source data and PowerBI.


However I have two questions to the new datamart.

1) I want to setup a datamart linked to a SQL DB, but here I need to add historical tables to show actual sales May 2022 vs forecast made in May 2021 etc. Can it be used to also create "history tables" in the Azure SQL DB behind the datamart?

2) Can I access the Azure SQL DB behind in the "Microsft Azure Portal" without using PowerBI?


Thank you in advance!

Community Champion
Community Champion

1) You can create snapshots in dataflows using the Bring Your Own Storage option. Then you can load these snapshots from ADLS Gen 2 in your datamart.


2) No, the datamart's SQL database can't be managed from the Azure portal. It is accessible via a SQL endpoint put that's purely so that you can query the views generated in the database by the datamart.

1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals
Community Support
Community Support

Hi  @KasperJ90 

(1) I don't quite understand that you mentioned "historical tables" , in what form does it exist ? 

I tested a scenario. Create a datamart, then connect to SDL, after loading the data from SQL, I connect to the Excel data source again, and the data inside is also successfully loaded into the datamart. At the same time, the dataset automatically generated by datamart contains these two data sources, and I can create a report with the data of these two data sources at the same time.


(2) For your second question , you can access the Azure SQL DB in datamart .But I don't quite understand what is "behind in the "Microsft Azure Portal" without using PowerBI" , can you explain it in detail ?


Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yetao1-msft 

1) Thank you for your effort. Maybe an example could help.

Let's say I have SQL DB with a sales table in a company including both actual sales and forecasts. I want to show in PowerBI/Excel what is in that sales table today, but also the same date last year. This way I can see how the actual sales is today compared to the forecast last year. How can I set this up with datamarts?
2) I mean can I access the datamart created via PowerBI via the Azure web portal? This will give better control and possible I could also add further data to the SQL DB created by the datamart.

Thank you for your time and help!

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors