You’re offline. This is a read only version of the page.
2
Hi,
I'm a relatively new user of Power BI and I've just created a simple set of queries in Power Query based on a Web API.
The first query pulls in the data via API and then the other queries are simply referenced to that query. There are 6 queries in total.
When I click Apply Changes in Power BI, I get the error message "We cannot convert the value "" to type List.".
I have unticked "Enable Load" on all 6 queries in turn and they each work individually without issue but whenever I try to load 2 or more at the same time, I get the above error.
Here's the part of the query that pulls the master table in:
let url="https://REDACTED",
body="{""APIKey"": ""REDACTED"",""Action"": ""GetQueryResultByQueryName"",""QueryName"":""REDACTED""}",
Source = Json.Document(Web.Contents(url,[
Headers = [ #"Content-Type"="application/json"],
Content = Text.ToBinary(body)
]
)),
Result = Source[Result],
#"Converted to Table" = Table.FromList(Result, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Other than that, I've renamed, re-ordered, filtered and removed a few columns but nothing too exciting.
Grateful for any help you are able to provide.
Thanks.
Matt.
An update - I have stripped back the steps to identify the issue (nothing was being flagged automatically) and it appears to be within the "Converted to Table" step. Suggests something wrong with the type of data that is feeding in but I can't understand why each query still loads perfectly well on its own but it fails with two or more.
Share
Report
All responses (
Answers (
