Am i allow to download only 3 out of 10 field from CSV file ?

[Paulyeo11]

Hi All

For some raw data , now i only to work on 3 field for now , and in future will i be able to add by load more field to PBI. does it able to work this way ?

[amitchandak]

@Paulyeo11 , what you mean by download. I doubt there is three column limit to load data in power bi.

If want to copy data from power bi, refer : https://www.youtube.com/watch?v=1_XlyzV-PcY

[Paulyeo11]

Hi Amit

what i mean is my CSV file have total 20 field , i dont want to load 20 field into my PBI and delete those 16 field i don't need , instead i want to load only 4 field which i highlighted for now , and infuture if i need load more field from below raw data , will i be allow to add ew field to load again ? 

[ryan_mayu]

@Paulyeo11 

you can do this in PQ, remove columns.If you want to show other columns, you can delete the remove step and do it again.

[Paulyeo11]

Hi Ryan

My question is when loading stage i delete those column i need now , and after 1 month later , if i need to load more field , do i allow to add another 6 more field from the same raw data table.

Paul Yeo

[ryan_mayu · Accepted solution]

@Paulyeo11 

Yes, you can do that. You can find the remove steps in PQ, you can undo the remove step to see all the fields and delete what you don't need again.

hope the doc below is helpful.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview