Forum Discussion

mthomas1973's avatar
mthomas1973
Helper I
4 years ago
Solved

Scorecard Data Model

Good morning.    We are starting to use PowerBI scorecards which is great and I like the fact that I can use the data model for these to create our own custom dashboard.    Is it possible to 'add...
Need Help
  • Burningsuit's avatar
    Burningsuit
    4 years ago

    Hi mthomas1973 

    You need to turn on the preview option "Direct Query for PBI datasets and AS" in Power BI Desktop

    This will enable you, once you've connected to the Goals Dataset, to further connect to other datasources and relate them in to the model.

    see: Power BI Composite Models | What’s The Big Deal? | Burningsuit

    You can then add your own date table, or indeed any other data you want to relate with the Goals..

     

    Hope this helps

    Stuart

Burningsuit's avatar
Burningsuit
Resident Rockstar
4 years ago

Hi mthomas1973 

You need to turn on the preview option "Direct Query for PBI datasets and AS" in Power BI Desktop

This will enable you, once you've connected to the Goals Dataset, to further connect to other datasources and relate them in to the model.

see: Power BI Composite Models | What’s The Big Deal? | Burningsuit

You can then add your own date table, or indeed any other data you want to relate with the Goals..

 

Hope this helps

Stuart

  • mthomas1973's avatar
    mthomas1973
    Helper I
    4 years ago

    That was really helpful thank you. I banged my head against a wall for a bit before I realised that scorecards in your own workspace won't work with this. Once I used it from a different workspace all fell into place!

     

    Thank you again.