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
Pragati11's avatar
Pragati11
Super User
4 years ago

Hi dheslin ,

 

When you say - "Why would power querry within power bi not identify all the rows of data"; I understand that you are trying to check all the rows in data in Power Query window.

I must mention here that Power Query editor doesn't load every single row from you data-source, as it shows few rows.

 

In order to check if the data is loaded completly in Power BI, check the data under Data section as shown below:

 

Can you confirm that here you see the right data?

 

Thanks,

Pragati

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