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
    Solution 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Smauro Thanks for the reply.

      I have a query parameter in my rest API which filters data based on date which is like "sysparm_query=sys_created_on>%3Djavascript%3Ags.dateGenerate(%272020-07-07%27%2C%2700%3A00%3A00%27)"

      as you can see its uses a java script for date format and also formats the operators like greater than or equal to for processing.

       

      how can i pass this value in my web content as parameter?