DM_GWPipeline_Gateway_MashupDataAccessError

[kanga99]

I am getting extra key phrases from the AIFunctions and all runs well on Power BI desktop.

When I am trying to refresh on the Power BI web I get this error:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We cannot convert the value \"[Function]\" to type Function."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Onboarding_1279_topicos_8506.

Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net

Activity ID: 23c43e9c-9002-4608-b49b-3c5dfa08be8b

Request ID: 568499f4-ca82-91b6-ee75-e345230dbb10

Time: 2024-03-08 18:14:34Z

Those are the steps that I applied:

let

  Origen = Odbc.Query("dsn=OPI AWS", "with topicos as (#(lf)select a.contact_company_id,#(lf)a.survey_id,#(lf)a.hora fecha,#(lf)a.respuesta pregunta_8506,#(lf)row_number() over (partition by contact_company_id order by a.id_respuesta) row_id#(lf)from opidb.v_allied_global_surveys_companyid a#(lf)where survey_id =1279#(lf)and a.id_pregunta = 8506#(lf)and a.finished=1)#(lf)select * #(lf)from topicos#(lf)where row_id=1"),

  #"Changed Type" = Table.TransformColumnTypes(Origen,{{"fecha", type date}}),

  #"Applied Extract key phrases" = AIFunctions.PostProcess(Table.AddColumn(#"Changed Type", "Extract key phrases", each #"Extract key phrases"([pregunta_8506], null)), "Extract key phrases", "CognitiveServices.ExtractKeyPhrasestexttext") meta [FunctionBrowser="TextAnalytics"],

  #"Removed Columns" = Table.RemoveColumns(#"Applied Extract key phrases",{"pregunta_8506", "row_id", "Extract key phrases"}),

  #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Extract key phrases.KeyPhrase", "pregunta_8506"}}),

  #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [pregunta_8506] <> null and [pregunta_8506] <> "")

in

  #"Filtered Rows"

Can someone help me please?

[Anonymous]

Hi @kanga99 

According to your error message, there should be a problem with the gateway, have you configured the relevant gateway on the Service? if not, you can refer to the following post to configure the gateway and then refresh it.

Solved: Adding ODBC datasource to gateway - Microsoft Fabric Community

Solved: PowerBI Gateway - specific ODBC setting on gateway - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao

[kanga99]

Thanks for the response. This helped me to solve the issue.

[Anonymous]

Hi @kanga99 

I am so glad that I could help you ! I will change the status to "Delivered" .

Best Regards,
Community Support Team _ Ailsa Tao