Summary
In this chapter, we discussed the limitations of the native Parquet connector in Power BI. You learned that these limitations can be overcome by using specific packages in both Python and R. We are talking about Dask and Arrow, the latter being available in both APIs for Python and R. In the last part of the chapter, you saw how to use these techniques in a Power BI report to append new data to very large datasets and query them in a very short amount of time.In the next chapter, we'll finally start working with R and Python scripts in Power BI, doing data ingestion and data transformation.