AndyGilly Posted August 4, 2020 Share Posted August 4, 2020 Hi i have been using the R Script integration to Power Bi, i have tried to update the data this morning and get the following error. Any ideas what this may be??? Has been working fine until yesterday ERROR DataFormat.Error: Unable to translate bytes [E2][80] at index 1083 from specified code page to Unicode. thanks Andy Link to comment Share on other sites More sharing options...
Steve G Posted August 4, 2020 Share Posted August 4, 2020 Hi @AndyGilly, I've seen this before, and it's usually down to the Windows smart-quote characters finding their way into the dataframe that R is returning to Power BI. If you change csvEncoding variable in the R script to ISO-8859-1 then you should see your data returned to Power BI again - but with those pesky characters replaced by something that Power BI can handle. Let me know how you get on. Cheers, Steve Link to comment Share on other sites More sharing options...
AndyGilly Posted August 4, 2020 Author Share Posted August 4, 2020 @Steve G, thanks so much for the quick reply , that has worked , i will update my version of the script Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now