Get data from an excel file in onedrive with power query

My knowledge of Power Query is limited, but as far as I know, Microsoft changed the way OneDrive generates shareable links, and the new short URLs like https://1drv.ms/... are redirect URLs, not direct links to the file content. This breaks Power Query's ability to connect via “Get Data from Web”, since Power Query cannot follow these redirect-style or tokenized links to fetch the actual file.

To get Power Query to work, you need a direct download link to your file (a .xlsx or .csv), not a preview or redirect link.

This only works with public or "anyone with the link" shared files.

If you move or rename the file in OneDrive, the resid will change — so the link will break.

Excel for Web and Power Query can't access files via .ms short links or tokens like EWvuc8k....

If you're frequently working with these files, sync the OneDrive folder locally and use Power Query to connect to the local path — it's more stable and supports refresh.

My answers are voluntary and without guarantee!

Hope this will help you.