Excel - need progress bar in excel during processing and some enhancement

Question

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.

Answer 1

Replied on MS Tech Community (here)