How to debug queries on Databricks for your PowerBI dashboard created with the import mode?

The import mode loads all the data to PowerBI which makes debugging more challenging. To facilitate the debug, you can ask for termporarly switching from the import mode to the direct query mode and monitor the executed queries on Databricks Query History.