Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Connecting to PowerBI Datamart

Hi

I started to check the PowerBI Datamart.

I was wondering if I can connect from Power BI Desktop to PowerBI datamart?

 

General Comment
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    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

4 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    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

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    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

  • otravers's avatar
    otravers
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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.