Forum Discussion
Helper IError updating google sheets with merge query
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?
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.
1 Reply
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.