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...
Hi, So unfortunately I cannot share the information with you. in the two files there are approx 50 columns pretty much as you described in your test. I have no issues with other file updates ,only this one for some reason. I was thinking it may be related to the excel file being flat page of data rather than an table but powr BI promotes the headers anyway and turns it into a table so i cant see that being an issue? I'm really lost as to why.... Any other advice?
- When you have it open in Power BI Desktop and click 'refresh' does it refresh as expected?
- Are there relationships between the two tables configured in the data model?
- Is the data and report visuals in the same PBIX file?
- Can you confirm the Gateway Refresh history shows success every time?
You could try turning on the 'Additional logging' in the gateway to see if that provides any useful info.
Really, at this point, any additional info you can provide may be useful.
I'll see if I can summon anyone else who may know.