Forum Discussion
Get Api Data from Web Api Connection
Go to Power Query and select the correct query. You should see something like this:
Click List.
Then click 'To Table' on the top left. Click 'OK' on the prompted window. You should see this as below
Click this button circled above. Uncheck the option in the 'Use original column name as prefix' then click OK. You will see several more columns that have this option as well once it is expanded. That is because there is a nested list. Do the same for those columns and make sure to click 'Expand to New Rows'.
Hope this helps!
Go to Power Query and select the correct query. You should see something like this:
Click List.
Then click 'To Table' on the top left. Click 'OK' on the prompted window. You should see this as below
Click this button circled above. Uncheck the option in the 'Use original column name as prefix' then click OK. You will see several more columns that have this option as well once it is expanded. That is because there is a nested list. Do the same for those columns and make sure to click 'Expand to New Rows'.
Hope this helps!
It worked perfectly!!!!!
Thank you very much!!!!!