Forum Discussion

DesNaidoo's avatar
DesNaidoo
Frequent Visitor
5 years ago

Dynamic M Query Parameters - is snowflake supported

Hi 

 

Im interested in the new dynamic parameter functionality for PowerQuery. Does anyone know if Snowflake is supported as a data source? Does anyone have any experience regarding how to improve the direct query from PowerQuery to snowflake so that it does not attempt to select everything from the table? Is there any way to control how the query is made?

 

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
Need Help
Tips and Tricks

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi DesNaidoo ,

     

    Please kindly refer to:

     

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

     

    For snowflake, you can choose to Import data directly into Power BI, or you can use DirectQuery. You can learn more about using DirectQuery. Please note that AAD SSO only supports DirectQuery.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • DesNaidoo's avatar
      DesNaidoo
      Frequent Visitor
      5 years ago

      Hi Stephen

       

      I was actually referring to the new Dynamic M Query parameter functionality that was introduced that has the parameter binding to slicers. Would that work with snowflake? 

      • julianadiaz0's avatar
        julianadiaz0
        Frequent Visitor
        4 years ago

        Hi, did you get a solution on this? My report was working fine with the slicers bined to 2 date parameters. After I think the april update it stopped working. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi

    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your problem.


    Best Regards,
    Stephen Tao

  • Fossil1974's avatar
    Fossil1974
    Frequent Visitor
    4 years ago

    Hi, I am also very interested to know whether and how dynamic M parameters are supported in Power BI if Snowflake is the datasource. I would appreciate an answer very strongly.