Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Issue with Excel Spreadsheet (Sharepoint Online) as a Data Source

I am having an issue with a report which uses Excel spreadsheets as data source (scheduled export - 3 times a day).

 

Error: Data source errorDataFormat.Error: <ccon>File contains corrupted data.. </ccon>;File contains corrupted data.. The exception was raised by the IDbCommand interface. Table: XXXXX

 

The refresh worked fine until 14/05/2023. 

 

  1. We have tested a manual export of a report. This has failed.
  2. We have run a refresh with archived data and this has worked.

 

Error message is provided in two different places.

 

Online in the service:

Data source error: DataFormat.Error: <ccon>File contains corrupted data.. </ccon>;File contains corrupted data.. The exception was raised by the IDbCommand interface. Table: XXXXXX

 

- Error found in right of refresh highlighted with a "!".

Offline in desktop:

Expression.Error: The key didn't match any rows in the table.

Details:

Key=

Item=Page 1

Kind=Sheet

Table=[Table]

- Error found in transform query in the "source" step.

 

Any help would be appreciated. 

 

Thanks

Status: Needs Info
Comments
Anonymous
Not applicable

Hi @mh94 

I also use ServiceNow Scheduled Reports, which arrives as an attachment to my email.
I made the PowerAutomate configuration so that every time the email with the subject arrives it automatically saves the attachment in the sharepoint according to the image I sent in the previous post.
And after that powerbi services updates the report.

Tahall
Regular Visitor

Hello everyone,

 

I had the same problem, which is now fixed.

I tried to export ppt as svg images for my power bi background.

But the background of ppt presentation was not in svg format.

After i changed the background to be also svg, the export has suddenly worked well and the import to power bi as well.

Hope it helps you.

 

Have a nice day.