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
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
