Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Value cannot be null power bi query

Hi All, Need help I am running a simple query to extract the data from the rest API based on the date query variable. Below is my query   let dtquery=Text.From(#date(2020,7,7)), Source=Json.Docu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

the main suspect seems to be the second null of this expression:

 

#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

 

you could try .

 

1)  remove all optional parameters then use  #"Converted to Table" = Table.FromList(Source) and see ...

2) should set the second null to some value.  I dont know the role and the scope of each parameter of this function and the MS docs don't help very much on this aspect, but we (i.e. you) can experiment ...

 

 

Smauro's avatar
Smauro
Icon for Solution Sage rankSolution Sage
6 years ago

Anonymous's issue must be with:

Web.Contents("https://serviceinstance.xxxx.com/api/now/table/incident?&sysparm_display_value=true&sysparm_exclude_...", [Query=[dt=dtquery]])

when it actually runs, it probably gets transformed to:

Web.Contents("https://serviceinstance.xxxx.com/api/now/table/incident?&dt=dtquery")

try adding all queries in the [Query=[]] record