Forum Discussion
Adding a data colmun when loading CSV files with JSON
I ended being able to use some logic to get the date from the Month or the report and the Report Generation Date.
Anonymous
This is information about the files you need, such as 'Date accessed', 'Date created' and 'Date modified'
To obtain this information you must obtain data through the FOLDER option
Or use the POWER QUERY M language functions.
Im not sure if Im clear on what your suggesting. In the first pic in my orginal post I have the dates of the files and link to the CSV files but when I import the CSV that date column is removed and I end up wth the second picture.
Anonymous
Can you provide an example json file?
Or Please try and test using it.
http://community.powerbi.com/t5/Integrations-with-Files-and/An-json-example/m-p/57447
Best Regards,
RfrancaI ended being able to use some logic to get the date from the Month or the report and the Report Generation Date.