Forum Discussion

Al345's avatar
Al345
Frequent Visitor
5 years ago

Dynamic M Query Parameter with Redshift

I am testing the Dynamic M Parameter feature and I'm having trouble getting it to work once it is published to PBI Service. I am connecting to a Redshift database which I believe is an M based connec...
Need Help
Al345's avatar
Al345
Frequent Visitor
5 years ago

Thank you but I have reviewed that documentation and Redshift is not in the list of unsupported sources. I found another article (not from Microsoft) that indicated that Redshift is an M based connector and should thus be compatible with this functionality. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Al345 ,

Could you share the below information with us in order to make troubleshooting?

1. The codes in your Advanced Editor (please mask the sensitive data)

2. How did you set your virtual table with parameter values? Which data type are they?

Note: Please DON'T select the type as "Any" when set the data type for parameter list

Best Regards