Forum Discussion

ThomasDay's avatar
ThomasDay
Impactful Individual
6 years ago
Solved

Simple US Census Data Feed?

Hello all, This probably falls into the "is it really this hard?" category, but I was hoping to find a simple way to get Population and Income data by zip code (a Zip Code Tabulation Area).  The mos...
Need Help
  • ThomasDay's avatar
    ThomasDay
    6 years ago

    Hello all and v-lid-msft 

    I did piece together a simple query using a json example from the census data api.  Here it is if anyone is looking to jumpstart their census exploration process.  It's easy to get an API key...just "apply" here: https://api.census.gov/data/key_signup.html As you look thru the api offerings, you'll see descriptions, variables, geographies (who knew this could be so confusing), groups, examples (sample api URL's)...which I've put in the Json.Document Function below in the simple PowerBI query..  There are keywords and parameters but this gets anyone going.

    I've lined out the key in the example below

    The table that this produces is shown, in part, here.  So that gets stuff into PowerBI

    Ok, enjoy,

    Tom

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi ThomasDay ,

 

Sorry for late reply, we cannot understand your requirement clearly, are you missing some fields when using Web Connector to get some data from a feed url?

 


Best regards,

 

  • ThomasDay's avatar
    ThomasDay
    Impactful Individual
    6 years ago

    Hi v-lid-msft ,

     

    Thank you very much for getting back to me.

     

    I guess I was asking for something even more basic.  I'm looking for an example Power Query which access a census data set and pulls it into a data file.  I'm just stuck on JSON (unfamiliar), and Census (complex) and I am having a hard time getting started.  If I can get a toe in the door...I can start working my way into the data.

     

    Thanks for checking in and any ideas would be appreciated.

    Tom

    • ThomasDay's avatar
      ThomasDay
      Impactful Individual
      6 years ago

      Hello all and v-lid-msft 

      I did piece together a simple query using a json example from the census data api.  Here it is if anyone is looking to jumpstart their census exploration process.  It's easy to get an API key...just "apply" here: https://api.census.gov/data/key_signup.html As you look thru the api offerings, you'll see descriptions, variables, geographies (who knew this could be so confusing), groups, examples (sample api URL's)...which I've put in the Json.Document Function below in the simple PowerBI query..  There are keywords and parameters but this gets anyone going.

      I've lined out the key in the example below

      The table that this produces is shown, in part, here.  So that gets stuff into PowerBI

      Ok, enjoy,

      Tom