Table is Empty - Power Query

[AllisterB]

Hi

I want to test in a Power Query if the Excel Table (t_AccrTrialBalance) is empty. If so then display a message and stop the Query otherwise do the transformation. how do I do this ?

Thank You


My code at present is
let
Source = Excel.CurrentWorkbook(){[Name="t_AccrTrialBalance"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type any}, {"Column3", type text}, {"Column4", type text}, {"Column5", type any}, {"Column6", type any}, {"Column7", type any}}),
#"Removed Top Rows" = Table.Skip(#"Changed Type",5),
#"Transposed Table" = Table.Transpose(#"Removed Top Rows"),
#"Cleaned Text" = Table.TransformColumns(#"Transposed Table",{{"Column1", Text.Clean, type text}}),
#"Transposed Table1" = Table.Transpose(#"Cleaned Text"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table1", [PromoteAllScalars=true]),

in
#"Promoted Headers"

 

[AllisterB]

Thank You Sandy

 

[sandy666]

You are welcome

 

[sandy666]

it should work like this

 

[AllisterB]

it should work like this

Mine didnt quite work like that- can you sahre the M code for eth Query with me Thank You

 

[sandy666]

// Warning
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Warning = if Table.Profile(Source)[Count] = Table.Profile(Source)[NullCount] then "All values are null" else Base
in
    Warning

// Base
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"Sales Order", "Make"}, {{"Count", each _, type table}}),
    Model = Table.AddColumn(Group, "Model", each List.Distinct([Count][Model])),
    ExtractModel = Table.TransformColumns(Model, {"Model", each Text.Combine(List.Transform(_, Text.From), ","), type text})
in
    ExtractModel

two queries: Warning and Base. Warning is an "error" query, Base is your transformed query or whatever you want to do there.
from Warning you should call Base
after all you can load Base into the sheet

 

[sandy666]

correction:
after all you can load Base into the sheet
after all you can load Warning into the sheet