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...
I cannot repro the same issue in Mar 2017 version of Power BI Desktop. Please refer to following video and let me know if there is any difference between our repro steps.
Best Regards,
Herbert