data ingestion workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1350933%22%20slang%3D%22en-US%22%3Edata%20ingestion%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1350933%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20used%20one%20of%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3Bawesome%20workbooks%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Eunion%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eisfuzzy%3C%2FSPAN%3E%3CSPAN%3E%3D%3C%2FSPAN%3E%3CSPAN%3Etrue%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E(%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3ETable1%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3ERec%3C%2FSPAN%3E%3CSPAN%3Eor%3C%2FSPAN%3E%3CSPAN%3Eds%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Ecount%3C%2FSPAN%3E%3CSPAN%3E()%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3ETableName%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3D%26nbsp%3BType%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EVend%3C%2FSPAN%3E%3CSPAN%3Eor%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22Table1%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eextend%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EPotentialDataSource%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eiif%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3ERec%3C%2FSPAN%3E%3CSPAN%3Eor%3C%2FSPAN%3E%3CSPAN%3Eds%3C%2FSPAN%3E%3CSPAN%3E%26gt%3B%3C%2FSPAN%3E%3CSPAN%3E0%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%3E%22%3Awhite_heavy_check_mark%3A%26nbsp%3Bdata%26nbsp%3Bis%26nbsp%3Bingested%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%3E%22%3Across_mark%3Ano%26nbsp%3Bdata%22%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E)%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E(%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3ETable2%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3ERec%3C%2FSPAN%3E%3CSPAN%3Eor%3C%2FSPAN%3E%3CSPAN%3Eds%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Ecount%3C%2FSPAN%3E%3CSPAN%3E()%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3ETableName%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3D%26nbsp%3BType%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EVend%3C%2FSPAN%3E%3CSPAN%3Eor%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22Table2%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eextend%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EPotentialDataSource%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eiif%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3ERec%3C%2FSPAN%3E%3CSPAN%3Eor%3C%2FSPAN%3E%3CSPAN%3Eds%3C%2FSPAN%3E%3CSPAN%3E%26gt%3B%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%3E%22%3Awhite_heavy_check_mark%3A%26nbsp%3Bdata%26nbsp%3Bis%26nbsp%3Bingested%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%3E%22%3Across_mark%3Ano%26nbsp%3Bdata%22%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E)%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E1.%20while%20using%20it%20as%20a%20workbook%26nbsp%3Bwhen%20data%20ingestion%20is%20stopping%20the%20%22No%20Data%22%20is%20shown%20for%20a%20few%20minutes%20and%20than%20disappear%26nbsp%3Bfrom%20the%20results.%20how%20can%20i%20keep%20it%20consistent%20until%20data%20is%20ingested%20again%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E2.%20how%20can%20i%20auto%20refresh%20the%20each%20windows%20in%20the%20workbook%20or%20the%20entire%20workbook%2C%20as%20it%20servers%20as%20a%20monitoring%20console%2C%20is%20there%20another%20solution%20than%20refreshing%20the%20pages%20%3F%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1350933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edata%20ingestion%20workbook%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1351023%22%20slang%3D%22en-US%22%3ERe%3A%20data%20ingestion%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1351023%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F501739%22%20target%3D%22_blank%22%3E%40MIkushOmri%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you.%26nbsp%3B%20In%20this%20case%20I'd%20recommend%20(unless%20you%20add%20a%20browser%20extension%20to%20refresh%20the%20workbook%20page%20-%20which%20I've%20not%20tried)%2C%20actually%20adding%20the%20reports%20to%20a%20Azure%20Dashboard.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDashboards%20allow%20a%20refresh.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Annotation%202020-04-30%20195054.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188043iD925892D6703D87C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-04-30%20195054.jpg%22%20alt%3D%22Annotation%202020-04-30%20195054.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdjust%20your%20query%20window%2C%20to%20enable%20the%20push%20pin.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Annotation%202020-04-30%20194807.jpg%22%20style%3D%22width%3A%20900px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188044i8012988B78AB1CF4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-04-30%20194807.jpg%22%20alt%3D%22Annotation%202020-04-30%20194807.jpg%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20pin%20that%20to%20a%20Azure%20Dashboard.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

i have used one of @Clive Watson 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 ?
1 Reply
Highlighted

@MIkushOmri 

 

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.

 

Annotation 2020-04-30 195054.jpg

 

Adjust your query window, to enable the push pin.  

 

Annotation 2020-04-30 194807.jpg 

Then pin that to a Azure Dashboard.