Forum Discussion
Power BI Only Loading Partial Data from Excel Files on SharePoint/OneDrive for Business
can you explain what the significance of using sharepoint.contents over sharepoint.files.
can you also explain what binary.buffer is and what parquet is?
SharePoint.Contents : slightly better performance as it directly addresses a folder rather than enumerating the entire sharepoint document library folder structure
Binary.Buffer: Prevents SharePoint from trying to be cute with sending data chunked. Rather orders Sharepoint to deliver the entire file in one piece
Parquet: Data storage format. Different from CSV (which is organized in rows), Parquet is organized in columns, and carries meta data. It is the foundation for the Direct Lake format used in Microsoft Fabric. Generally CSV and Parquet files ingest very fast, regardless of their size.