I can’t share the notebook, it is private in paid subscription. The entered number (or anything else) does not affect the query. The data frame in the report disappears (becomes empty) when I click the “Recalculate all” button.
So, in a python cell I have just, df_1 and I select this cell to be included in the report. Like this, there is the problem that I describe.
I eventually got this to work by using the following:
from IPython.display import display, HTML
display(HTML(df_1.to_html()))
And then I include this cell in the repot.