Forum Discussion

Andregewehr's avatar
Andregewehr
Icon for Helper I rankHelper I
3 years ago
Solved

Error 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 refre...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.