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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Using R or Python script text column without accent

Hi, I need R or Python script to transform column "Name" to column "Name" without accent.

I have downloaded R Open and tried this.

# 'dataset' holds the input data for this scriptdataset$text <- iconv(dataset$text, from = 'UTF-8', to = 'ASCII//TRANSLIT')output <- dataset

ERROR:

Formula.Firewall: Query 'Employees' (step 'Run R script') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Anyone who has experience with this?

3 REPLIES 3
lbendlin
Super User
Super User

That's the regular formula firewall warning - use the standard methods to work around that (privacy levels etc)

 

What's preventing you from doing this in Power Query directly?

Solved: How to remove accents from a column using Power Qu... - Microsoft Power BI Community

 

 

Anonymous
Not applicable

I dont understand.

What do you mean in PBI Query directly?

The community discussion youre sharing is the one i followed and used the script from

http://datacornering.com/how-to-convert-accented-characters-to-unaccented-in-r-or-power-bi/

Hi @Anonymous 

 

You can try the solution provided in the 5th message in the community discussion you followed. It uses Power Query without R. I have tested it and find it work well. 

 

For the error you met, can you provide your M code from Advanced editor? According to the error message, Query 'Employees' (step 'Run R script') references other queries or steps, did you do any modifications in it? Which other queries or steps are referred?

 

I found some articles and discussions related to this error, you may find them helpful.

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Docs

Data Privacy and the Formula Firewall in Power BI / Power Query — The Power User

Solved: Formula.Firewall: Query references other queries, ... - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

 

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors