Record in an attribute column. "This step is evaluated outside the datasource".

[Krishna09]

Hello,

I am creating a dataflow to import sharepoint file data to dataverse.

In the process, I have clicked on record in attribute column. from then In my applied steps , it shows "This step is evaluated outside the datasource".

Now I want to know what will this effect?

2. how to change it to normal?

3. I am trying to import this data to an existing dataverse table. Will this effect the process?

[Krishna09]

@AntrikshSharma Thank you fo your explaination.

[AntrikshSharma · Accepted solution]

@Krishna09 The meaning of the Step is that the Query will not fold and all the of transformations will be performed inside Power Query, for example if you connect Power Query to a Database then some steps of PQ can be computed in the database itself like GROUP BY, Selecting, Removing columns, multiplication, etc. this improves the performance as Databases are more optimized for these operations, so it is recommended that Query Should fold as much as it can in a database.