Forum Discussion
Power Query not identifying all rows from excel unless I resort in excel and save???
I have two excel files that are generated from an Alteryx workflow that obtains information from SAP. These two files are the only data source for a Power BI build. The refresh of these files happens...
Did you resolve this? Do you know the version of Excel the file is saved as? I have the same issue. I receive an email each morning with an excel file from Cognos and use Power Automate to save it in a SharePoint folder. If I refresh (from desktop or server) it only reads the first 45K lines of the file. If I first open and resave the Excel file, and then refresh, it reads the entire file in. I'm not sure if the issue is the version of Excel Cognos saves the file as or if it is something with Power Automate or SharePoint Online.