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

Hi Yes if i use the data view i can see the total rows. 

For example here is todays values after I have resorted the excel file outside of Power BI. I will check tomorrow and put the value i find here v's the value that is in the excel file.  It will be different, i will then perform a sort and save on the file and show the updated table data screen shot so you can see my issue.

 

Pragati11's avatar
Pragati11
Super User
4 years ago

Hi dheslin ,

 

You really don't need a sort to see number of rows in your data under the DATA section in Power BI. It should always show you total rows that Power BI has loaded from the data source.

 

Thanks,

Pragati