Welcome back to this week’s edition of the Power BI
blog series. This week, we look at datamarts.
Datamarts in Power
BI were officially announced in May 2022 as a new Power BI Premium self-service
capability that enables you to perform relational database analytics and
uncover actionable insights from their data.
You can now easily
discover and connect to datamarts from the ‘Data hub’
within the Power BI Desktop Ribbon. This
feature allows users to discover datamarts that have already been created and
reuse them to easily build reports.
You will be able to
see datamarts that you have created or that have been shared with you by others
in the organisation. This will connect
you to the datamart’s underlying auto-generated dataset (using live connect) so
that you can easily create reports.
To create datasets
on top of the datamart, you can use the Azure SQL database connector and specify
the Datamart’s SQL connection string for Server name. If you created the datamart, you can get the
SQL Connection string from datamart settings (context menu action from the
datamart in your workspace):
If this datamart was
shared with you, you can get the SQL connection string from the Datamart info
page below from the Data Hub (in Power BI Service) (see more on the Data Hub
below).
Apparently,
Microsoft has stated that the plan is to simplify the experience to connect to
the datamart’s SQL endpoint so that advanced use cases may be served easily without
the hassle of having to find the connection string.
Check back next week for more Power BI tips
and tricks!
Be the first to comment