Forum Discussion
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...
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.
Thank you so much for posting this. It helped us with the same error message.
In our case, the issue was resolved by adding an error handling step (Table.ReplaceErrorValues) immediately after retrieving the data from the source.
let
Source = [Your data source query],
// Immediately clean any error values
CleanedData = Table.ReplaceErrorValues(
Source,
List.Transform(
Table.ColumnNames(Source),
each {_, null}
)
),
// Continue with your normal transformations
[Rest of your steps]
in
[Final step]