Error while get data from blank query

[chrisyan_manalu]

Hi All, 

I have code like this to get the data 

(SelectedService as text,Authentication as text) =>
let
#"BaseURL" = "My URL",
#"ConstantVar" = "My authorization",
response = Web.Contents(
#"BaseURL",
[
Headers = [Authorization= Authentication],
RelativePath = #"ConstantVar" & SelectedService
]
),
jsonResponse = Json.Document(response),
Navigation = jsonResponse[data],
#"Navigation 1" = Navigation{0},
#"Converted to table" = Record.ToTable(#"Navigation 1"),
#"Transposed table" = Table.Transpose(#"Converted to table"),
#"Promoted headers" = Table.PromoteHeaders(#"Transposed table", [PromoteAllScalars = true])
in
#"Promoted headers"

And I got error message like this 

Anyone know how to solve this case ?

Please help

Thanks

[v-yingjl · Accepted solution]

Hi @chrisyan_manalu ,

That usually means that you are trying to perform operations on an empty table or list.

Based on your query, you may check this one:

#"Navigation 1" = Navigation{0}

You need to make sure that all the tables or lists should be no blank which have been stored in the data source, then you can check the first table since the query quotes it{0}.

In addition, you can use try otherwise statement in this query mentioned by @ lbendlin to check that if the first table not work, otherwise connects to other tables from the source.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[lbendlin]

use the try ... otherwise ...  feature of Power Query to handle this situation graciously.