Forum Discussion

Vishall's avatar
Vishall
New Member
11 years ago

Getting this error while importing Local Excel file - "Failed to publish Excel workbook"

Hi,

 

I am trying to import Local excel file into Power BI however continuosly getting an error as "Failed to publish Excel workbook".

 

Below are some technical details

 

Activity Id29a8c5ef-4657-4790-9494-480931bc3737
Request Id1b2eedf2-5b72-7992-d66e-4de3e8b0e9cf
Status Code409
TimeFri Jul 24 2015 19:32:26 GMT+0530 (India Standard Time)
Version11.0.9167.449
Cluster URIhttps://wabi-south-east-asia-redirect.analysis.windows.net

 

Please suggest.

5 Replies

  • jbocachica's avatar
    jbocachica
    Resolver II
    11 years ago

    Is your excel file open?, go to the task manager and verify that there is no process using your file.

     

    Regards

  • ashishrj's avatar
    ashishrj
    Power Participant
    11 years ago

    Vishall verify you connection through Power Query. Try refreshing data and see if it works. If not then there is issue with your existing connection to data source and hence it fails when publishing to Power BI. Hope this is useful!

    • andre's avatar
      andre
      Memorable Member
      11 years ago

      I would also make sure that your Excel file is less than 250MB and has no more than 10 reports.

  • lubosbednar's avatar
    lubosbednar
    Helper I
    11 years ago

    I have the same problem when I want to replace existing dataset after a few changes made localy. I can upload it as a new file without any problem, but replacing it cause this error message above. 

     

    It is frustrating, because I have already built a many reports above this dataset. And if I create new one, I would throw them all away :(

     

    Thanks,

    Lubos

    • lubosbednar's avatar
      lubosbednar
      Helper I
      11 years ago

      Small update:

       

      I have found out that problem is when I have the same excel attached as PowerBI report as well as PowerBI data model. It cause that I cannot overide existing data model. Howerver when I remove PowerBI Excel report then model can be replaced using upload.