Dynamic M query parameters - directquery back to Redshift?

[Anonymous]

With the new February 2022 Update, adding more SQL flavors available to call back to for directquery, does anyone know if its possible to directquery to Redshift as your SQL database and pass the parameters back successfully in this context?

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

The limitations do not explicitly say no, and I am about a week out from getting access to Redshift in order to test. Just wondering if anyone has walked through this door yet. 

[v-luwang-msft]

Hi @Anonymous ,

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

And I I found another article (not from Microsoft) that indicated that Redshift is an M based connector and should thus be compatible with this functionality. 

You also could refer the following article:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-redshift 

Redshift Direct Query - Using (List) Parameters

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien