Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to make PBI load additional field from sharepoint folder load CSV file ?

Hi All

At frist i load the below CSV file using SharePoint folder load :-

 

One month later , Due to user new request for more COGS field to be load on CSV file :-

 

It there a way that make PBI load all the new field add to CSV file ? As now PBI will still keep loading only 2 fields and not load COGS field. Any work around ? 

 

In case it is not possible , may i know usually how all of do ? 

 

Paul Yeo

  • Anonymous , Open Edit Query/Transform data mode. And then right-click on the table and open advance editor, In case you see a source column list carefully add the new one to the list.

2 Replies

  • Anonymous , Open Edit Query/Transform data mode. And then right-click on the table and open advance editor, In case you see a source column list carefully add the new one to the list.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Amit 

      thsnk you very much