Last row in excel table won't load to PowerBI

[Joey_P]

Hello,

I'm trying to figure out why the last row in my excel table won't load into Power BI? For added information, the data in my table is fed through a Power Automate flux that includes an AI builder model to extract the information from a pdf document.

If anyone knows a solution, it would be greatly appreciated!

[aj1973]

Hi @Joey_P 

Can you show me screenshot of the whole Power Query please?

[Joey_P]

Actually, here is the screenshot from the table in my post!

[aj1973 · Accepted solution]

there you go

[Joey_P]

That did it! Thank you @aj1973 !

[aj1973]

Welcome @Joey_P 

[Joey_P]

Hi @aj1973 ,

Here is the screenshot!

[aj1973]

Il y a un filtre appliqué quelque part dans ces étapes qui fait éliminer la ligne

Check out which one it is.