We were unable to load this Excel file because we couldn't understand its format

[nok]

Hi!

When I try to update my published PBI dashboard on PBI Services, it always displays this error:

However, when I try to update the same PBI on my desktop, it updates normally, without any issues. This error only occurs in the published version, and the excel files that this dashboard uses are not corrupted.

 What can I do to solve this?

[v-achippa]

Hi @nok,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @MFelix and @srlabhe for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @nok,

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @nok,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[MFelix]

Hi @nok ,

What is the format that the excel file xls, xlsx, xlsm? And where is it stored, sharepoin, onedrive, local drive (using a gateway)?

In previou reports I had some issues with the xls files connecting on the service altough they worked perfectly in the Power BI desktop.

[nok]

Hi @MFelix 
The Excel files are in xlsx format and are stored in folders in Sharpeoint. I really don't know why only PBI Services gives an error when updating, but on Desktop it updates without any error.

[MFelix]

Do you have any password on the file?

[nok]

There is no password in the file. It is showing the data normally.

[MFelix · Accepted solution]

Hi @nok ,

I know that probably you have done some checks but try the following:

• In Power BI Service, please check the dataset settings and make sure that the SharePoint connection is using “Organizational account”.
• Check if the Excel file has any broken links, hidden sheets, or damaged data.
• Try removing the connection to this file in Power BI Desktop, connect it again freshly, and then publish the report once more.

 I apoligize for probably asking to do some steps that you already have done but is just some debug options.

[srlabhe]

Try changing its format to xls and saving in some different folder.