Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi
I started to check the PowerBI Datamart.
I was wondering if I can connect from Power BI Desktop to PowerBI datamart?
Solved! Go to Solution.
Hey @Anonymous ,
when you create a Power BI datamart, there is also a dataset created with the same name as the datamart.
With Power BI desktop you can connect to that dataset with the connector for Power BI datasets:
or:
From then on it's identical to a connection to any other Power BI dataset.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
For me it is more interesting to connect to the datamart using the sql server connector.
the name of the server is the connection string that appears here
that way you will be able to take advantage of any of the datamart tables and add them to your model.
If you connect to the dataset you can only use data from that dataset and that can be frustrating.
I hope you serve the recommendation!
Best regards
f
You didn't specify which part of the datamart you wanted to connect to. You can either connect to the Direct Query dataset as explained by @selimovd above, or to the SQL database via its connection string.
Hey @Anonymous ,
when you create a Power BI datamart, there is also a dataset created with the same name as the datamart.
With Power BI desktop you can connect to that dataset with the connector for Power BI datasets:
or:
From then on it's identical to a connection to any other Power BI dataset.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
76 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |