Update .CSV Files when amending the data -

[Daniel_B]

Hi All

I've tried the simple Google search but I seem to get more complicated versions of what I assume to be a simple update of a file

In short, I've made some changes to a .CSV file which is the source of my report yet when I go to Edit Query -> Source Settings (cog) then remap the file again it doesn't show any of my changes

Is there a simple way of updating the file if I make changes

They're infrequent so I don't need anything autonymous just something manual is fine

Thanks

Dan_B

[mwegener]

Hi @Daniel_B ,

is your problem solved?

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener]

Hi @Daniel_B ,

or you try to Clear your Data Cache at the Options.

[mwegener]

Hi @Daniel_B ,

did you press the Refresh Button on the Ribbon?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Daniel_B]

@mwegener I did indeed.. Yet the metric seems to remain the same which is why I thought there might be a more complicated solution

I haven't moved the files and no errors appear when I hit refresh or edit the query so I'm kind of at a loss

Any ideas what could be the root cause?

Thanks for reaching out

[v-chuncz-msft]

@Daniel_B 

You may review data in Query Editor and check code in The Advanced Editor.

[mwegener]

Hi @Daniel_B ,

is the file in a synced directory like OneDrive?

[Daniel_B]

@mwegener - nope, just in a folder I have set up specifically for these inputs in "My Documents"

[mwegener]

Hi @Daniel_B ,

could you post your Advance Editor M-Script?

[mwegener]

Hi @Daniel_B ,

did you solve your problem?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.