Forum Discussion
Query Not Capturing All Rows from Data Folder
Very difficult to troubleshoot. How many files? How many rows in the files? Any errors in the query, check data quality. Any erros in the query, are you possibly doing something inadvertant in your query that could cause rows to be dropped?
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Hey Greg,
Thanks for the response! There are only 4 excel files that should be pulling in from the source folder. There should be a total of 30,589 rows (between 3,000 and 19,000 rows in each file) but the query is only getting 27,310. There are no errors in the query.
What is weird to me is that if I copy and paste the exact same code from the advanced editor into a blank query in a new pbix file, it works. What I ended up doing to get it to work is copy and paste into a blank query in a new pbix file and save that file. Then copy and paste that same code from the advanced editor into my original file and it worked. I must have been doing something inadvertently here but I'm not sure why it works in a new clean file. Oh well, crisis adverted. Thanks again!