Forum Discussion
Adding a data colmun when loading CSV files with JSON
I am using json to pull the CSV files for the data on my monthly Azure summary billing. Below is what it looks like before I import the CSV files. You can see I have a row for each month of the y...
I ended being able to use some logic to get the date from the Month or the report and the Report Generation Date.
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,
Rfranca
I ended being able to use some logic to get the date from the Month or the report and the Report Generation Date.