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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
