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
     

     

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