Issue with dataset and report Refresh

[edwinlau]

Hi,

I have published a report and dataset on power BI service form desktop and have issues with refreshing the dataset.

Have checked that the credentials to access the data  and the respective data format is correct.

Below shows the error message:

Data source error: DataFormat.Error: <ccon>File contains corrupted data.. </ccon>;File contains corrupted data.. The exception was raised by the IDbCommand interface. Table: ARMG Report (2).
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 12daebde-441b-4970-b232-00ae1d7d0a3d
Request ID: c3273890-d029-106c-3386-d03d5d2aa169
Time: 2023-02-14 00:44:00Z

This is observed when i do both manual and scheduled refresh.

The datasets are linked to Sharepoint using webURL and there is no issues with manual refresh on local desktop. 

Appreciate any help to resolve this issue.

[collinq · Accepted solution]

Hi @edwinlau ,

I found this thread that has some solutions  Solved: File contains corrupted data - Microsoft Power BI Community]

I also discovered that you can't use a password protected file or a file that might have special characters in the data fields.

Let us know if this helps!