Not able to pull data in Excel

[helios_me]

Solved!

I had to first go to Get Data->Data source settings->Edit Permissions and edit Type.
And then type the URL.

Thank you Kal Lam!