Hi - I have imported an excel file into Power BI using Sharepoint and I am getting this error. I cannot edit the excel file as it has a lot of data and I am having issues with excel if I open the file. The file is not password protected. Is there any way I can sort this error without editing the excel file. Any help is appreciated. Thanks in advance!
Hello @J0676s ,
you need to spot the fields that are making the error and replace them. You could acheive that in Power Query, check the replace option.
check this out https://youtu.be/6Jgbzjrsa8g?si=vv6LcSzcc0-eW3Zz
Proud to be a Super User! |  |
Thank you for your response.
I am not able to access the dataset because of the error so cannot replace or transform the data in anyway
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 35 | |
| 32 | |
| 27 | |
| 23 | |
| 16 |
