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 following error:

Underlying error code -2147467259
Underlying error message Information is required to combine data
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources[{"kind":"GoogleSheets","path":"https://docs.google.com/spreadsheets/d/1b8Rm_XKcUQYK2H7DhLQBi4-Fy-KUshEHxfVAiz7dixQ/edit#gid=0" },{"kind":"Folder","path":"C:\\Users\\Personal\\Desktop\\Stock\\PowerBI Emp Project\\Data\\Kits"}]
Microsoft.Data.Mashup.MashupSecurityException.ReasonPrivacySetting
Cluster URIWABI-BRASIL-SUL-B-PRIMARY-redirect.analysis.windows.net
Activity ID42883f4b-81c6-4e23-bb1b-7a00e01c4260
Requester ID168ec235-b831-784d-e026-3c846004cb25
Time2023-03-22 15:23:50Z

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?

[v-tangjie-msft · Accepted solution]

Hi @Andregewehr ,

Based on the error message you provided, it appears that the issue may be related to a privacy setting on your Google Sheets data source. Power BI requires certain permissions to access and combine data from multiple sources, and if the privacy setting on your Google Sheets data source is set too high, it may be preventing Power BI from accessing the data.

To resolve this issue, you can try adjusting the privacy level in data source credentials, Power BI desktops, and Power BI servers to Public or None.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.