Forum Discussion
RomanTesolkin
1 year agoFrequent Visitor
Oracle Query Folding Error: Non-null assertion failure: resource should be available for query
Getting a persistent cache/query folding error when refreshing Oracle queries in Power BI Desktop. The exact error is: Non-null assertion failure: resource should be available for query "QueryNam...
- 10 months ago
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...
pieter_nuyens
11 months agoNew Member
Hello Is this bug already fixed ? I'm havingthe same erros with direct queries to Oracle with dynamic parameters.