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
amitchandak's avatar
amitchandak
Super User
5 years ago

Al345 , As per the document, this supported on following:https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

 

 

  • The feature is only supported for M based data sources. The following DirectQuery sources are not supported:

    • T-SQL based data sources: SQL Server, Azure SQL Database, Synapse SQL pools (aka Azure SQL Data Warehouse), and Synapse SQL OnDemand pools
    • Live connect data sources: Azure Analysis Services, SQL Server Analysis Services, Power BI Datasets
    • Other unsupported data sources: Oracle, Teradata and Relational SAP Hana
    • Partially supported through XMLA / TOM endpoint programmability: SAP BW and SAP Hana

 

  • 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