Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Andregewehr
Helper I
Helper I

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 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?

1 REPLY 1
Andregewehr
Helper I
Helper I

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors