Forum Discussion

mdw's avatar
mdw
New Member
1 year ago
Solved

Power BI Non-null assertion failure

Anyone seen this - "Non-null assertion failure: resource: Resource should be available for query (queryname) to store FoldedArtifacts in cache"?   Power BI wants me to report this issue to Microsof...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for parry2k's concern about this issue. 

     

    Hi, mdw 

    I am glad to help you.

     

    May I ask what type of data source are you using? What operation is being performed that is causing this error? Is a very large dataset being used?


    In Power BI, this error may occur if the dataset is too large or the query is complex such that the memory consumed by the query or calculation exceeds the configured limit.


    If this is the reason, you can try to optimize your dataset by simplifying the query and removing unnecessary columns to reduce memory consumption.
    If you are using import mode to connect to the data source, you may also want to consider using DirectQuery mode or Live Connection mode to connect to the data source.

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for parry2k's concern about this issue. 

 

Hi, mdw 

I am glad to help you.

 

May I ask what type of data source are you using? What operation is being performed that is causing this error? Is a very large dataset being used?


In Power BI, this error may occur if the dataset is too large or the query is complex such that the memory consumed by the query or calculation exceeds the configured limit.


If this is the reason, you can try to optimize your dataset by simplifying the query and removing unnecessary columns to reduce memory consumption.
If you are using import mode to connect to the data source, you may also want to consider using DirectQuery mode or Live Connection mode to connect to the data source.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

moone33's avatar
moone33
Frequent Visitor
1 year ago

The operations is when I click on the refresh button on the Home menu.  This error occurs on small and large datasets.  It only happens on the ones with Incremental refresh is enabled.  When I disable Incremental refresh, no error, no matter if it is large or small dataset.  I forgot to add it still refreshes the dataset