© Ryan Wade 2020
R. WadeAdvanced Analytics in Power BI with R and Pythonhttps://doi.org/10.1007/978-1-4842-5829-3_6

6. Reading Data into the Power BI Data Model via an API

Ryan Wade1 
(1)
Indianapolis, IN, USA
 

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, ...

Get Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.