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...
I'm experiencing the EXACT same issue: Alteryx workflow appends data to an existing Excel spreadsheet, but PBI Power Query fails to recognize the newly appended data unless maunally sorting the Excel spreadsheet first.
Did you every find resolution for this? Any feedback would be GREATLY appreciated, thanks.
I had the same issue with an Alteryx append and was able to resolve it with the below thread.. specifically the comment from DavidSkaife about changing the code in the Source step. That code was easy to find if just importing one file but I was doing a Combine Files so then the code is in the Transform File function in the Helper Queries area.