Parameterized invoking of notebooks does not work

Question

I am trying to run multiple notebooks from the data we have, so I am using for each and @item().NotebookName. However, Synapse is failing, it can't find the notebook, even though notebook name is clearly the same as the value passed. Am I missing something? These notebooks are still in my branch. I guess I will need to use mssparkutils.notebook.run

Answer 1

One possible reason is, when you are invoking the notebook where notebook name specified with a dynamic expression, the particular notebook should be published prior to that or else it will give the below error.

Here, I got same error when notebook name given through dynamic expression and notebook was not published.

It will identify the unpublished notebooks only when we are giving the notebook from the dropdown.

So, publish all your notebooks before the pipeline execution and then debug the pipeline. Now, it will identify the notebook from the dynamic expression.