Forum Discussion
Power Query not identifying all rows from excel unless I resort in excel and save???
I've created a file with 52 columns and over 320,000 rows and it updates no problem.
Using the personal mode gateway but I doubt that would have a material impact.
Even with that many columns and rows the file is only sitting at 70,152 KB, but that is likely down to data types. I'm certain you're not anywhere near any file limitations.
Do all of your updates in the Power BI Service always show success?
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.