Need help with removing apostrophe while from data

Hello AmeenVanakar ,

you can add a "Column from Example"

follow the following link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example

Best regards,
DivKlearner – A Bit Forward Daily
Join us as we explore and learn IT together.
Discover simplified IT learning on YouTube

Shivu-2000,  DivkLearner , Irwan,  Thank you for the prompt response!
Hi AmeenVanakar ,

Thanks for reaching out to the Microsoft Fabric Community forum.
In addition, To Shivu-2000 , DivkLearner , Irwan Let me also share an additional insight :
1. Once load the data, please refer the below steps :
In the Power Query Editor, select the column(s) that contain apostrophes.

• Use the "Replace Values" feature:
  • Right-click on the column header and select "Replace Values."
  • In the dialog box, enter the apostrophe (') in the "Value to Find" field and leave the "Replace With" field empty.
  • Click "OK" to apply the changes.

    Below is the screenshot for your reference:

     

    

    2. Here are the results generated using the above approach.

    

    If my response answered your question, feel free to mark it as a solution to help others find it easily! And if you found my reply helpful, don't forget to give a "Kudos" – I’d truly appreciate it! 
    
    Best regards,
    ThankYou.

     

     

HIi AmeenVanakar ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

Hi AmeenVanakar ,

We noticed we haven’t heard back from you regarding our previous response. If it resolved your query, kindly mark it as Accept Answer and click Yes if you found it helpful. Doing so can also benefit other community members.

If you have further questions related to this thread, feel free to let us know, and we’ll do our best to assist you.

For any unrelated issues, we recommend starting a new thread so we can address your query effectively.

Thank you!