Hi All,
I'm using an excel which allows user to choose Json file and with help of power query and macro, json is breaking into TABs with rows and columns.
![117022-image.png][1]
Excel is showing info of file, location and filename and I'd like to add one more parameter UserName which will show who upload particular json file like this ..
![117032-image.png][2]
Also, when clicking on Refresh json Table button things get start to break json file in desired format .
I want to bring a progress bar with % completion on screen instead of traditional excel message in bar during this time.
I attached my excel file with sample json file here.