Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
use the try ... otherwise ... feature of Power Query to handle this situation graciously.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |