Forum Discussion

mimiles's avatar
mimiles
Frequent Visitor
9 years ago

O365 Excel opening error for PowerBI source file

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 attemp...
mimiles's avatar
mimiles
Frequent Visitor
9 years ago

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.

Image

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.

Image

 

Any suggestions for solving this are welcomed! Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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