Forum Discussion

dheslin's avatar
dheslin
Regular Visitor
4 years ago

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...
Need Help
dheslin's avatar
dheslin
Regular Visitor
4 years ago

Good morning the file sizes are around 104,000 KB of data or less and the row counts are currently around 300000 each (2 files) both displaying the same problem.

 

Once the power bi report scheduled refresh has occured the page should show the correct lines from the files but it does not. When i press the refresh button the values don't change until i have sorted and saved the excel original files and refreshed the data model.  Very odd. The refresh button does work though as you can see the visual update once i have refreshed the data model.

KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

That is odd. I'm intrigued.

Is there anyway you could share the files with me? Masking any sensitive data obviously.

I realise that may be a difficult task. I could create similar size files but I don't think I'm going to run into that problem.

 

How many columns in each file?