Forum Discussion
Power BI Desktop Table is empty
Hi all.
If in case my question was not clear. i want to simplify that question.
Actaully iam looking for something like this query below. If Source data table is empty or blank, then i want to source the data again and if table is not empty, then pass it.
The below query syntax is not correct, but i want to show an example that iam expecting somthing like this.
let
Source = Web.Contents("https://www.xxxxxxxx.com/us/en/store-finder/find?query=45505"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".name-address.col-3 > .name"}, {"Column2", ".name-address.col-3 > .address"}}, [RowSelector=".name-address.col-3 > .name"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}}),
#"Kept First Rows" = Table.FirstN(#"Changed Type",1)
Result = if Table.IsEmpty(#"Extracted Table From Html") then Source
else #"Extracted Table From Html"
in
Result
Thanks in advance!
Thanks,
Shijin