Power BI Integration

[AndyGilly]

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

[Steve G]

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

[AndyGilly]

@Steve G, thanks so much for the quick reply , that has worked , i will update my version of the script