SQL query binding parameter to other table

[Anonymous]

Dear All

I would like to ask you about problem that i facing, I created SQL query that is working correctly, I created the parameters,

but if i bind the parameters to tInjectionValues, than nothing is working.

tInjectionValues is direct query table.

After this binding report is not working

biding was done as described here Unlock the power of dynamic parameter binding for ... - Microsoft Power BI Community

I think it would be better not used query and binding but measure directly used for tInjetionValues, but i was not successful to create one.

Can you please advice me what is best approach for this issue?

Thank you very much

Best regards Jakub

[Fowmy]

@Anonymous 

It seems the type is not valid for the Factory parameter.

Edit Factory parameter and change the Type to TEXT.

In your Query, do not use Number.ToText

[Anonymous]

Thank you for your reply but this didn't help.