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
     

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity 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.