Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a query that pulls in all excel files in a folder that contains a single spreadsheet of sales for every month. The average row in each on is around 55,000. Everything has been great until recently after adding the latest month sales I seem to be missing data.
I filter the appended data set to that month I am missing almost 10,000 rows as the queiry only counts 59k but the spreadsheat actually has 68k.
This is the first month this as happened. I have looked at the file and right at the row it cuts off and there is nothing wrong with the data, I don't recieve any warnings or issues when I refresh the data. I have tried removing two months of sheat from earlier years and refreshing to see if it was a limitation.
Nnot sure what else to troubleshoot, any ideas would be very appreciated!!
Hello
Did you find a solution to this problem?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |