This is not the first page I have encountered - I previously had issue with this for another page that I don't recall anymore.
Anyway since I have encountered it again I thought I'd ask.
I have created Web Services page for 518 and I can pull it through Odata connection from PowerBI But it gives me an error through EXCEL.
I copy pasted the link and it opens up in web and PowerBI but not in excel.
EXCEL:
PowerBI:
For most pages I have no problem loading from Excel-Power Query but this one is giving me an error.
Would there be any explanation why this happens and if there is a way that I should be able to load it through excel as well?
Thanks,