reduce columns of imported dataverse tables

[DiePic]

Hi all

there is a way to import from Dynamics Dataverse

not the entire table, but only the 4-5 columns of interest?

thanks in advance for any suggestion or ideas.

[DiePic]

Hi @Anonymous  and thanks for reply.
This is not what I'm searching.
I want limitate/reduce the loading of columns from the source and I will explain why.....
I work with Dynamics Sales and upload the table systemuser that has more than 100 columns and I need only 3 (name, surname, mail).... I've done as you say, I've removed all the others columns ....in the last year somthing is  changed and the report return errors in updating ... this errors were because 1 of this 100 and more columns was deleted in the system.
If I can decide to upload only the 3 columns that I need, maybe this problem will be solved.

There is a way to do what Iwould like?

[Anonymous · Accepted solution]

Hi @DiePic ,

I suggest you to go into Power Query Editor, find Choose Columns in Home pane and select the columns you need.

For reference: Choose or remove columns

Alternatively, use Advanced Editor and find your SelectColumns statement and add it in there manually.

Best Regards,
Rico Zhou

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