Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Changing source with a reduced CSV file

Hi dear community,   I work to set a reporting weekly refreshed. The problem is I made my reporting with a huge exctraction (30 columns, 50mb), and for performance reasons we decided to now use a l...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you for your quick response. 
I made what you suggest until my Power Query step where I delete my non essentials columns. 
I suppose I maybe have to delete those columns upstream in my original CSV file ? But I expect my Power Query will dont run at all from the start then ?

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello Anonymous ,

 

Just look at the advanced editor to see the M code for the applied steps and search for the removed columns if they're still referenced.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I get what you suggest ! But in the M code of the my deleting step I have to refer to my suppressed columns.