Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.