I've created a quick demonstration video on how you can use Web Services to build reports for Excel and Power BI.

If you have any questions on where to find data head over to the community forums and ask - https://community.dynamics.com/business/f/758#pi53924=1