data ingestion workbook

[OmriPinsker]

i have used one of @CliveWatson awesome workbooks:

union isfuzzy=true

(

Table1

| summarize Records = count() by TableName = Type, Vendor = "Table1"

| extend PotentialDataSource = iif(Records>0,":white_heavy_check_mark: data is ingested",":cross_mark:no data")

),

(

Table2

| summarize Records = count() by TableName = Type, Vendor = "Table2"

| extend PotentialDataSource = iif(Records>1,":white_heavy_check_mark: data is ingested",":cross_mark:no data")

),

1. while using it as a workbook when data ingestion is stopping the "No Data" is shown for a few minutes and than disappear from the results. how can i keep it consistent until data is ingested again

2. how can i auto refresh the each windows in the workbook or the entire workbook, as it servers as a monitoring console, is there another solution than refreshing the pages ?

[#2]

@OmriPinsker 

Thank you.  In this case I'd recommend (unless you add a browser extension to refresh the workbook page - which I've not tried), actually adding the reports to a Azure Dashboard. 

Dashboards allow a refresh.

Adjust your query window, to enable the push pin.  

 

Then pin that to a Azure Dashboard.