Error updating google sheets with merge query

[Andregewehr]

Hi people,

I have two sources: a google sheets and an excel file. In the power query editor I made a "Merge Queries" in the google sheets to merge with the excel file.

But when I try to refresh in the app.powerbi.com, i get the error: -2147467259

Underlying error message: Information is required to combine data
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259

All my Data sources credentials are correclty set.

This error only occurs when I make the merge queries. Does anyone know how can I refresh a google sheets source when I make the merge?

[Andregewehr]

I identified the error. In the datasource credentials, in the Power BI desktop and in the Power BI server, you must adjust the Privacy Level as PUBLIC! My was set as NONE. Hope help anyone! Peace!