Forum

You should be using "The second table" which you say "a single record for the keys used for merging" as your primary file (top file in the Merge dialo...

I did a search for "power query authentication for google docs" and found this doc: Power Query Google Sheets connector - Power Query The bad new...

This YouTube video should help: Get Google Sheet Data in Excel with Power Query: If you have Excel 2021/365, you can try this LAMBDA function: ...