Python filenotfound error in Power BI

Hello js15 

Not sure if you have done this, please try this 

Go to the location on OneDrive where the excel is saved.

Click on the three dots next to the file name > Details

In the pane on right; click "more details"

You should see "Path" with some squares, you can click that it will copy the location of the file.

In PBI; just do a web source and paste that path as the URL

or 

Open the Excel file in OneDrive
• Go to File > Share > Embed
• Copy the embed code and extract the URL

 Then try this

import pandas as pd

url = "https://onedrive.live.com/download?resid=YOUR_RESID&authkey=YOUR_AUTHKEY"
df = pd.read_excel(url)

see if this helps

Thanks

Hello js15,

Thank you for bringing your concerns to our attention. We also appreciate nilendraFabric  for providing a solution. However, we apologize that the provided solution did not resolve the issue. Please consider raising a Microsoft support ticket using the link below:

https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
 

If this helps, kindly accept it as a solution and give a "Kudos" so other members can find it more easily.

Thank you.

Thank you., I was able to fix it through by just uploading the files to the resources tab on the left side, you can also do it through a lakehouse as well. Thank you so much for the help!