O365 Excel opening error for PowerBI source file

[mimiles]

I'm running into issues opening an Excel file in O365, which is also my source file for a Power BI dashboard. The Excel file is ~1.3 MB with nine worksheets. I receive the following error when attempting to open in my browser, but after one or two browser reloads it opens correctly.

Ever since running into this issue with the Excel source file, my Power BI dashboard doesn't refresh when I try to apply query changes. I've already tried recreating a new version of the Excel file and changing that to be the source in Power BI but it still doesn't work.

Any suggestions for solving this are welcomed! Thank you.

[mimiles]

I'm running into issues opening an Excel file in O365, which is also my source file for a Power BI dashboard. The Excel file is ~1.3 MB with nine worksheets. I receive the following error when attempting to open in my browser, but after one or two browser reloads it opens correctly.

Ever since running into this issue with the Excel source file, my Power BI dashboard doesn't refresh when I try to apply query changes. I've already tried recreating a new version of the Excel file and changing that to be the source in Power BI but it still doesn't work.

Any suggestions for solving this are welcomed! Thank you.

[v-yuezhe-msft]

Hi @mimiles,

Firstly, regarding to the issue that you fails to open Excel file in O365, please post the question in the Office forum to get dedicated support.  Meanwhile, you can review the following similar threads to troubleshoot the first error.

Excel file unable to open online (One drive/sharepoint)
OnDrive error "Request was taking too long"

Secondly, the second error could occur when you put an invalid URL path to be the source in Power BI, please check if you can open the URL successfully in browser and follow the instructions in this blog to handle error 404 in Power BI.

Thanks,
Lydia Zhang