Based on your video and screenshot, the symbol is not space, it just looks like “space” in Power BI Desktop.
To investigate more details about the symbol, you can use HEX-Editor in Notepad++ to view the sample data 1 006,956, then compare the Ascii codes of the symbol and “space”. For more details about ASCII description, please review this blog.
Thanks, Lydia Zhang
Community Support Team _ Lydia Zhang If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yes it's not "space", but i believe Power BI "web connector" is taking data with wrong encoding, or just replacing it on the way, because data taken directly from web has 20 hex code (space) and data taken from Power BI - A0.