Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Clarification please - Questions on Query Folding, Native Query, and/with the use of Parameters

Hi, I have some questions that I would like clarified please. I'll based these questions on one of our scenarios of loading data from multiple Hadoop tables into Power resulting in producing a singl...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    8 years ago

    Hi Anonymous,

    For the first question, it depends on your data source and connection mode. You could refer to this link:

    https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

     

    For the left questions, based on my test, what ever the connection mode(or prarmeter) you are using, the query executed in the query folder(like the picture below in SQL Server):

     

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
8 years ago

Hi Anonymous,

For the first question, it depends on your data source and connection mode. You could refer to this link:

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

 

For the left questions, based on my test, what ever the connection mode(or prarmeter) you are using, the query executed in the query folder(like the picture below in SQL Server):

 

 

Regards,

Daniel He

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for the clarification.

    Hopefully this post/response will help others too.