Issues with PowerBi script

[chriscorcoran]

Just refreshing a report this morning and getting the following erro, nothing I know of has changed. I have set myself a new API key just in case but I still get 

 

ADO.NET: R script error.
Error: Argument 'txt' must be a JSON string, URL or file.
Execution halted
 

 

Any ideas?

 

[chriscorcoran]

I did notice a new script posted in git so I have tried thet but now get 

We encountered an error while trying to connect.
Details: "Unable to translate bytes [E2][80] at index 0 from specified code page to Unicode."

Tested on two seperate reports that use R and both fail with the same error.

 

[chriscorcoran]

My bad, typical man, hadnt read through readme, I forgot the issue of Details: "Unable to translate bytes [E2][80] at index 0 from specified code page to Unicode. is caused by UTF-8, chnaged it to ISO-8859-1 

This will usually be "UTF-8", but if you have issues returning data with certain characters (the Windows E2 80* characters are the usual culprits) then choose a different character set to use, ie: "ISO-8859-1" 

[chriscorcoran]

spoke to soon getting the following when I updated the script in my source settings 

OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).

[chriscorcoran]

I have gone back to the report it is using in Hornbill and when I export the csv the report is corrupt. Looks fine in preview. Are there issues with the reporting?

 

[Guest Paul Alexander]

HI @chriscorcoran

Is this the same as your problem? 

 

[chriscorcoran]

@Paul Alexander thanks, thats what I'm seeing.