Can you use a named range in a Power Query?

That’s just the way Power Query works. It either dumps output to a table or into the Power Pivot Data model. If you mean why does it convert the input range to a table, you can use a named range. Just make sure the entire named range is selected when you choose “From Table”.
For More Information Please Refer:


You May Also Like to Read: