Chapter 8: Loading Large Datasets beyond the Available RAM in Power BI

In the previous chapter, you learned how to read from and write to a CSV file, both with Python and in R. When it comes to reading a file, whether you use Power BI's standard data import feature or the techniques shown in the previous chapter, the main limitation on the file size is due to the amount of RAM available on the machine where Power BI Desktop is installed.

In a data enrichment phase, it may be necessary to extract information needed for ongoing analysis from very large files (terabytes in size). In these cases, it is almost always necessary to implement big data solutions to be able to handle such masses of data. Very often, however, it is necessary to import ...

Get Extending Power BI with Python and R 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.