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

Hi dheslin,

 

Where are the files stored?

What validation steps did you use in Power BI to confirm all rows weren't loading?

Can you post your power query code (remove anything sensitive)?

 

I'm sure we can get to the bottom of it with a little more detail.