Forum Discussion

connectprince's avatar
connectprince
Regular Visitor
1 year ago
Solved

DM_GWPipeline_Gateway_MashupDataAccessError

Getting the following error when refreshing the Power BI dataset using cloud refresh. The desktop refresh is working without any problem. I am connecting to an Enterprise Data Lake through an ODBC co...
Need Help
  • connectprince's avatar
    connectprince
    1 year ago

    I was able to resolve the issue by explicitly naming the columns in the table when accessing the schema.

    Please see below the step that was added to the query.

    pv_jobcosts_Table = Table.SelectColumns(dtl_radius_10_1_Schema{[Name="pv_jobcosts",Kind="Table"]}[Data],{"compnum","plantcode","jobcode","stepnum","costcatnum","costcatsubnum","costcattype"})

     

    The dataset is refreshing without any error after this was added.

connectprince's avatar
connectprince
Regular Visitor
1 year ago

I was able to resolve the issue by explicitly naming the columns in the table when accessing the schema.

Please see below the step that was added to the query.

pv_jobcosts_Table = Table.SelectColumns(dtl_radius_10_1_Schema{[Name="pv_jobcosts",Kind="Table"]}[Data],{"compnum","plantcode","jobcode","stepnum","costcatnum","costcatsubnum","costcattype"})

 

The dataset is refreshing without any error after this was added.