Composite model add column

[Anonymous]

Hello,

I would like to add a column to a fact table my composite model report. This is working perfectly in de dataset.pbix file, but not in the report.pbix. It gives the error: "The column 'Fact table[Column] cannot be pushed to the remote date source and cannot be used in this scenario."

Anyone has an idea to solve this?

Column =
VAR _VAR1 = 'Fact table'[Fact1]
RETURN
    MAXX (
        FILTER (
            'Category table',
            'Category table'[Low] <= _VAR1
                && 'Category table'[High] > _VAR1
        ),
        'Category table'[ID]
    )

[lbendlin · Accepted solution]

Do you own that fact table or does it come from a shared dataset?

I think what the error message is saying is that the query cannot be folded. Maybe use a different computation like CALCULATE(MAX()) to see if it results in a foldable query.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can't edit the dataset if you have read only permission. Please contact the owner for edit permissions.

Best Regards,

Jay

[Anonymous]

Thanks for your reply!

Composite models could solve a lot of the challenges I'm facing. Unfortunatly it has become a security/permission struggle that I'm losing. Beside this problem, I'm also having issues discussed in this topic. 

Simply adding a DAX two row table, to be able to create a slicer is so hard to accomplish. When working with just a single dataset, it's not desired to add all those small tables to the dataset. 

[lbendlin · Accepted solution]

Do you own that fact table or does it come from a shared dataset?

I think what the error message is saying is that the query cannot be folded. Maybe use a different computation like CALCULATE(MAX()) to see if it results in a foldable query.

[Anonymous]

Thanks for your reply @lbendlin.

No, I dont own the fact table. I only have read access at the moment. Is it important to own the data in order to create a calculated column in a composite model?

I want to create a column so I can create a relationship to a DAX created table. Don't think I should be using another computation because it's already giving me the correct results in the dataset. I assume a calculated column computation is identical in the dataset as in the composite model report.