Jump to content

Power BI Integration


Recommended Posts

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

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.

image.png

Let me know how you get on.

Cheers,

Steve

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...