Forum Discussion
Oracle Query Folding Error: Non-null assertion failure: resource should be available for query
The error is fixed. The powerbi parameter is a number. When you add this to the query string, you have be sure to remove the comma's and points. My solution is to use "F0" in number.to_Text(Parameter,"F0"). The parameter is an integer, so I don't need decimal signs.
No error anymore but it still didn't work like expected. It kept using the default value of the parameter. I tried to link the parmaeter with a column from an other table. But that didn't do anything.
I was able to make the performance better in the underling oracle database. So not urgent anymore...
Hi pieter_nuyens ,
If you are getting this error after incremental refresh, can you please try to disable once and check if you are still getting this error?
Thank you
The error is fixed. The powerbi parameter is a number. When you add this to the query string, you have be sure to remove the comma's and points. My solution is to use "F0" in number.to_Text(Parameter,"F0"). The parameter is an integer, so I don't need decimal signs.
No error anymore but it still didn't work like expected. It kept using the default value of the parameter. I tried to link the parmaeter with a column from an other table. But that didn't do anything.
I was able to make the performance better in the underling oracle database. So not urgent anymore...