- Change the general access to anyone with the link can view
- 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
- Use power bi to search for web data source and put this link.
