Forum Discussion
Importing Newly Added JSONs from Folder Source
Hi Tkre
Do you connect to folders with Power BI Desktop as this article "How to Load Data from a Folder in Power BI"?
Does the new file have the same structure as previous ones?
Best Regards
Maggie
- Tkre7 years agoFrequent Visitor
I follow that but have slightly different options since there's no combine and load. When I click combine and edit, it goes straight to the editor without a preview either.
In the editor I then get this:
I've then been filtering the rows to get just "ScanHistory" which has the entire scan time history for that work order mixed with the barcode data in each row. I was using transpose then merge to get all of them into a single cell then split using delimiters to break it out into a single long column and filtering out non-dates until I had only the date/time left. The problem was merge only selects the actual columns present during the step so every file added would add a column that wouldn't be included in that step.
Worst case I have the production software output into a seperate .csv in addition to the production files but I've really like to directly read the production data if possible to have a single source of truth.