Forum Discussion
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
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
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.
