1. Change the general access to anyone with the link can view
  2. After the end of the ID change it from /edit?usp=sharing to /export?format=xlsx&id= and add the id in for the document which is the first part of the document.
    • Example https://docs.google.com/spreadsheets/d/ABunchOfRandomCharactersAreHereToIdenitfyTheDocument/export?format=xlsx&id=ABunchOfRandomCharactersAreHereToIdenitfyTheDocument
  3. Use power bi to search for web data source and put this link.