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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
v-nmohamed
Employee
Employee

File contains corrupted data

Dashboard was refreshing normally and suddenly I started to receive this type of error when trying to refresh from Power BI Service. However, the dashboard refreshes normally from the Power BI Desktop version.

 

 

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, 

According to my research, this issue can be caused by multiple reasons, you can have a check:

 

Core excel > 30MB
Excel has password
Permission issue
Corrupted model
Wrong type, error format, value issue, etc.

 

If you still have a problem, you can try these steps to find if they can be useful:

 

First, make sure the PBI desktop is the latest version.
Then please delete the data source (File -> Options and Settings -> Data Source Settings) and reconnect to see if it works.
Please make sure all permission and credentials are correct.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-robertq-msft
Community Support
Community Support

Hi, 

According to my research, this issue can be caused by multiple reasons, you can have a check:

 

Core excel > 30MB
Excel has password
Permission issue
Corrupted model
Wrong type, error format, value issue, etc.

 

If you still have a problem, you can try these steps to find if they can be useful:

 

First, make sure the PBI desktop is the latest version.
Then please delete the data source (File -> Options and Settings -> Data Source Settings) and reconnect to see if it works.
Please make sure all permission and credentials are correct.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I found out there is an Excel sheet with "Highly Confidential" sensitivity, I excluded it from report refresh and it worked 🙂 I hope this was just the issue.

Thanks.

GilbertQ
Super User
Super User

Hi @v-nmohamed 

 

It looks to me like that could be a corruption issue


What happens if you re-upload the PBIX file?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Same problem happens.. the pbix starts to refresh again and then this error pops up.

v-nmohamed
Employee
Employee

Hello Gilbert,
I have the latest Power BI Desktop version and same for gateway but problem still persists. It works for other dashboards to be published on same workspace without any problem.. Same version same workspace and same everything but different dashboards.. there is a problem with this one specifically and the issue is not clear.

this is a snip of what I am getting as an error

Screenshot 2021-10-06 102213.png

GilbertQ
Super User
Super User

Hi @v-nmohamed 

 

Can you make sure you have got the latest version of Power BI Desktop installed, also make sure you have got the latest version of the On-Premise gateway installed and see if that solves your issue?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors