Forum Discussion
Power BI Only Loading Partial Data from Excel Files on SharePoint/OneDrive for Business
Hello Power BI Community, I'm encountering two major issues when trying to load data from Excel files stored in OneDrive for Business (via SharePoint Files in Power BI): Details: I am using Share...
Just to clarify how I’m gathering the data: Due to limited infrastructure in the company, the only way I can collect data is by having the ERP system send me scheduled imports via email in XLSX format. These files are then stored in a OneDrive Business folder through Power Automate, and the rest of the process follows from there.
im new to Parquet first time hearing about it now.. how can i convert to using parquet or in the powerautomate phase convert the xlsx file to csv before storing them in the onedrive folder?
as far as the binary buffer and sharepoint.contents solution i'll get back to you on whether that suffices or not.
See if you can get CSV extracts from your ERP system instead.