Forum Discussion
[ Problem with accentuation in power query ]
Hello everyone. I have the problem described in the image bellow.
Can a good soul explain to me why is this happening?? there are other problems when the accentuation is "Á" for example. All the columns are in the right locale (portuguese brazil).
thks in advance!!!
Hi bolabuga ,
What is your data source? What is the accentuation in data source? I think if the accentuation is "F_ORF?O", then it will show "F_ORF?O" in Power BI.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi bolabuga ,
What is your data source? What is the accentuation in data source? I think if the accentuation is "F_ORF?O", then it will show "F_ORF?O" in Power BI.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thks for the reply. I need to talk to the admin of the data source (which is Odbc.DataSource("dsn=), because this problem is happening in power bi and access.
I did a test similar to the one you showed, and the data is OK, when linked to a xlsx local file.
Edit: The data source is with the wrong accentuantion, i just got a reply from the data base admin.
