Google Sheets as Data Source

[mrhuguru]

Hey guys,

Trying to use Google Sheets as a source for my data model.

I successfully did it publishing my sheet as an excel file and using Power Query "from web" tool.

My only problem is I would definitely prefer not publishing nor making my sheets public.

Does anyone have a solution ?

Thank you so much,
Hugo