The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I recently encountered my Power BI Report (in Desktop) not pull in all the rows of an Excel table. I have the table named and sized correctly so I cannot figure out why it is excluding some rows? I even checked the data types of the missing rows and could not find any that were different from rows that do get pulled in.
Thoughts on this?
Solved! Go to Solution.
Hii @rmcgrath
Hii @rmcgrath
Hi @rmcgrath ,
That's unlikely to happen. Perhaps you could check if you are pulling the right excel table? Or are you pulling the excel worksheet instead?
Otherwise would be worth clearing cache and see if it helps the situation. Do give a kudos if this helps!