Hi Matthew, Thank you very much for your reply! I have replicated the code above for my table in Power Query and got the same result where the RecID column isn’t appearing beside the Src column that will expand into my table. (See Screenshot below) ...

Hi, Thank you so much for this it helped me a lot! I have a table which references other tables in my base. When I pull tables with less than 100 records into powerbi the normal way (entering url in web section of get data) they have id fields so tha...