It seems I've encountered a bug when using R in query editor in PowerBI desktop. I have an .xlsx with some cells end with "…", take the following one as example. 1 text 100 2 vertical… 10...
Thanks for your reply.
I've upgraded to April 2017, and followed the same steps in your video, and the issue persists. I'll test on more devices later.