Extending Power BI with Python and R - Second Edition

Answers

Chapter 1

1. The stages are data loading, data transforming, and data viewing.
2. You can’t use a Python dictionary as a data source. Only pandas DataFrames are recognized by Power BI as allowed data sources.
3. You can’t use an R list as a data source. Only R data frames are recognized by Power BI as allowed data sources.
4. In the case of both the Python script and R script, the name of the variable that contains the transformation data obtained up to the previous step is dataset.
5. You must drag the fields you want to use in your script to the Values area.
6. You must refresh the data in order to re-run a Python or R script added as a Power Query step (either in the loading phase or in the transforming phase) – or set a Page Refresh property for ...