The Best of new Power BI features in 2023 vol. 1

2023 brings a lot of great new features to Power BI. Here are the most important ones.

Datamarts

Datamarts help bridge the gap between business users and IT. Datamarts are self-service analytics solutions, enabling users to store and explore data that is loaded in a fully managed database. 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 semantic model 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.

Datamarts offer the following benefits:

• Self-service users can easily perform relational database analytics, without the need for a database administrator
• Datamarts provide end-to-end data ingestion, preparation and exploration with SQL, including no-code experiences
• Enable building semantic models and reports within one holistic experience

Datamart features:

• 100% web-based, no other software required