Field Parameters - Error when converting from live connection to directquery

[mattcarter865]

I know it's preview feature so there are bound to be bugs; That's why I'm bringing it up here.

I set up a Field Parameter list of measures in a shared published dataset. Then I create a thin report with a live connection to it. Field parameters work fine.

Then I change the thin report to use DirectQuery over PBI Datasets and AS connection, and the field parameter no longer works.

It seems this is caused by the fact that the JsonExtendedProperty on the fields column of the field parameter table does not propogate through to the local model when you switch it to DirectQuery. If you use Tabular Editor to add that property back in, it works again.

Field Parameters in Tabular Editor – Dobbs On Data

[agusmba]

Hi @v-jayw-msft.

I'm suffering Matt's same problem with PBI Desktop (november 2022) (Composite model againsts two published PBI datasets with field parameters, not working in the new report).

Do you know if this issue is being worked on?

Or should I just try Matt's workaround with Tabular Editor?

BTW, the "JsonExtendedProperty on the fields column of the field parameter table" is not present in the original published model, maybe the internals have changed?

NVM, I was not seeing the extended properties in TE. Kudos @mattcarter865 for posting the workaround!

Thanks!

   Agustín.

[v-jayw-msft · Accepted solution]

Hi @mattcarter865 ,

Thanks for sharing.

Best Regards,

Jay