Forum Discussion
Fields parameter with live connection (SSAS)
Hi 🙂
Field parameters need to be defined in the model, so can't be defined at report-level.
This is because the field parameter requires a table with (at minimum) a column containing column/measure references as text with the "Extended Properties" property set appropriately.
One workaround:
Are you connecting to SSAS Tabular 2022? If so, you could create a composite model instead with DirectQuery connection to SSAS Tabular. Then you could create the field parameter in the local model.
Now that I think about it, I'm not sure whether Azure Analysis Services or recent builds of SSAS Tabular 2022 would allow the field parameter table to be created there - would be interesting to test if that's an option for you.
Hi 🙂
Field parameters need to be defined in the model, so can't be defined at report-level.
This is because the field parameter requires a table with (at minimum) a column containing column/measure references as text with the "Extended Properties" property set appropriately.
One workaround:
Are you connecting to SSAS Tabular 2022? If so, you could create a composite model instead with DirectQuery connection to SSAS Tabular. Then you could create the field parameter in the local model.
Now that I think about it, I'm not sure whether Azure Analysis Services or recent builds of SSAS Tabular 2022 would allow the field parameter table to be created there - would be interesting to test if that's an option for you.
