Power BI Notebooks - Persisting Variables Between Sessions

Hi RockliffeBI ,

In Power BI Notebooks, by default, variables and their values are not retained between sessions.
To retain variables between notebook sessions, you can consider the following methods:
1. Use external storage:
Store the date of the last run in an external storage location, such as a file or database in Datalakehouse. On each run, read the stored date from the external location and then update it after a successful run. In this way, the notebook can always reference the last run date from the external storage.
2. Power BI Dataflow or Dataset:
If your Power BI environment allows it, you can create a dataflow or dataset in Power BI to store the last run date. The notebook can then query this dataflow or dataset to retrieve the last run date and update it accordingly.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly