Error loading Excel files from OneDrive Personal into Power Query

Please consider this:

• Verify the URL Format:
  • Ensure that the URL you are using is in the correct format for downloading files. The new URL structure with migratedtospo=true might indicate a backend change in OneDrive's file hosting.
  • Try generating a new download link by sharing the file and selecting the "Anyone with the link can view" option. Replace view.aspx with download in the URL.
• Use the Correct Privacy Level:
  • Double-check that the privacy level in Power Query is set to "Public" for the data source. Go to Data Source Settings in Power Query and confirm this.
• Test with a Different File:
  • Upload a new test file to OneDrive Personal and generate a fresh link. This can help determine if the issue is specific to certain files.
• Alternative Method:
  • If the above steps don't work, consider using the OneDrive API or a different method to access the file. For example, you can sync the OneDrive folder to your local machine and load the file directly from the synced folder.