Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Composite models not working

Hi, I would love to add a column to this report, that is connected live to a dataset. How can I enable the option to add a column?

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    you can only add a calculated column to a power bi dataset with the "DirectQuery for PBI datasets and AS" feature. This feature is still in preview, but you can use it already. In order to use it, you have to activate it in the Preview features settings:

     

    Be aware that currently this only works with a Power BI dataset and Azure Analysis Services data set.

     

    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
     

     

3 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    you can only add a calculated column to a power bi dataset with the "DirectQuery for PBI datasets and AS" feature. This feature is still in preview, but you can use it already. In order to use it, you have to activate it in the Preview features settings:

     

    Be aware that currently this only works with a Power BI dataset and Azure Analysis Services data set.

     

    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
     

     

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    5 years ago

    Hi Anonymous 

    When we use live connection we cant add columns/tables, we can only able to create a measures. You need to add required column to the datasource and use it in your report.

    Thanks.

  • dbeavon3's avatar
    dbeavon3
    Memorable Member
    3 years ago

    selimovd 
    I find that lots of people in this community are saying things like "you can only add a calculated column to a power bi dataset with the DirectQuery for PBI datasets and AS feature".

    In the general sense, adding calculated columns are not supported in DirectQuery for PBI datasets.

     

    When refreshing these datasets in the service, we get an error:

    Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery