Query Not Capturing All Rows from Data Folder

[Anonymous]

I need some help with using Folder as a data source. I am using a couple different folders as data sources for a report I am designing. I have spent several hours creating new columns and measures. When I presented it to the client, they believed the report to be inaccurate and incomplete. Upon further review, it looks like the the query is dropping off a few thousand rows of data for some reason. 

Any ideas on how this can be corrected? I have refreshed the data a bunch of times and it is not working. I also started a new blank query within the same pbix file and pasted the exact same code from the advanced editor and it does not work. When I do that to a brand new pbix file, it works for some reason. Having a hard time making sense of this so any help is appreciated. I could start from scratch but I will be losing 20+ hours of work. 

[Greg_Deckler]

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".

[Anonymous]

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!