Many governmental entities and private companies have made their data more accessible via Data APIs. Data APIs provide interfaces that enable you to programmatically retrieve data from data providers. The data sets that these Data APIs provide can bring great value to your Power BI data model.
Interfacing with Data APIs is hard to do using M code, but that is not the case with R and Python. In this chapter, you will learn how to retrieve and load data from the US Census via their Data API into the Power BI data model using R and Python. First, ...