Hello - I have MS Office 365 and I am trying to get an API to work in Excel. I copy the address, got to Data > From Web > paste the Address and hit OK and then ... crickets ...
I tried it on my work computer too and it works there so my guess is something (e.g. settings) is off but I can't figure out what. Are there any known issues with Excel/JSON connections? Is there something going on with Power Query I am not seeing? Thoughts? Thanks!
