Forum Discussion

h2022's avatar
h2022
Frequent Visitor
3 years ago

Data Mining Us Census Data

Hi everyone,   I am looking at some data sources, and I would love to be able to get the quickfacts info from the US census data into my Power BI report. Example: https://www.census.gov/quickfacts/...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi h2022 

 

I notice that if we use the input box to enter a state/city/..., the URL will be updated to include that state/city/... and the table will include columns of data for all these regions. 

 

To have data of all states, you may need to prepare a list of URLs in advance, which include all state name strings. Then query data from these URLs to get all the data. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • h2022's avatar
    h2022
    Frequent Visitor
    3 years ago

    Hmm yeah, I was hoping there was an easier way - like how they offer APIs for alot of their demographic data. I might just be better off going that route.

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      3 years ago

      I agree, it would be easier with APIs. Have you found whether this website provides APIs for these data? I haven't found any yet.