Forum Discussion
Oracle Query Folding Error: Non-null assertion failure: resource should be available for query
- 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...
Hi RomanTesolkin ,
Thank you for the update.
The idea was to help you riase the issue in the issues forum. If it would get enough votes, it will be resolved.
If you still need any assistance, please consider raising a support ticket here-
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Microsoft Fabric service status
Hope this helps!