Forum Discussion
How do I purge old data?
Is it a public URL that you can share? Also, can you share the Source line from your query so that we can see what M function you are using? Go into Query Editor and then click on Advanced Editor.
For example, there are specific options when retrieving content using Web.Contents for ignoring the cache.
https://msdn.microsoft.com/en-us/library/mt260892.aspx
This is an internal URL. I have remove the Columns=5 clause from the Source line already, as I was advised that might help things. Currently, import is failing because the cumulativeVolumes column is no longer present in the stream. What I need it to do is regenerate the headers from the CSV source.
Source = Csv.Document(Web.Contents("https://cosmos15.osdinfra.net/cosmos/Asimov.Partner.osg/shares/asimov.prod.data/PublicPartner/Processed/FileSystems/REFS/PowerBI/ReportReFSAdoption/ReportReFSAdoption.csv"),[Delimiter=" ", Encoding=1252, QuoteStyle=QuoteStyle.None]),
Thanks.
Perhaps try this:
Source = Csv.Document(Web.Contents("https://cosmos15.osdinfra.net/cosmos/Asimov.Partner.osg/shares/asimov.prod.data/PublicPartner/Proces...", Encoding=1252, QuoteStyle=QuoteStyle.None],IsRetry),
This should force it not to retrieve from cache.
Hi garykglenn,
Have you tried the solution provided by Greg_Deckler above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards
