Forum Discussion
Helper IMicrosoft.Mashup.Evaluator.Interface.ErrorException: Attempted to read or write protected memory.
Thank you for the reply.
It turns out that the issue was the code. The code I was passing through DirectQuery to the Oracle backend was in ANSI-89 format, similar to the below:
select a.id, b.id, b.address_1
from person a, address b
where a.id = b.idOnce the code was converted to ANSI-92 format, the error message went away.
select a.id, b.id, b.address_1
from person a
inner join address b
on a.id = b.idIs this documented somewhere? If not, this should be.
-Igor
Hi igordossantos,
In Power BI Desktop, please firstly go to File-> Options and Settings-> Options-> Data Load, clear cache in the following screenshot, then check if you can connect to Oracle successfully.
Alternatively, you can go to C:\Users\username\AppData\Local\Microsoft\Power BI Desktop\Cache to delete all files in Index and Temp folders.
Thanks,
Lydia Zhang
- igordossantos
Thank you for the reply.
It turns out that the issue was the code. The code I was passing through DirectQuery to the Oracle backend was in ANSI-89 format, similar to the below:
select a.id, b.id, b.address_1
from person a, address b
where a.id = b.idOnce the code was converted to ANSI-92 format, the error message went away.
select a.id, b.id, b.address_1
from person a
inner join address b
on a.id = b.idIs this documented somewhere? If not, this should be.
-Igor