Power BI - How to connect to an excel file in your sharepoint or teams

1.  Open file in sharepoint
2. Open file in excel
3. Go to File>Info>Copy Path
1. It will look like this 
2. https://mysite.sharepoint.com/sites/Shared%20Documents/myfile.csv?web=1
4. Remove the ?web=1 so the link looks like this
1. https://mysite.sharepoint.com/sites/Shared%20Documents/myfile.csv
5. In power BI>Get Data>Web>Enter this address>enter your login info