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.
GilbertQ
Super User
Super User
The error appears to be coming from your table due to data truncation on those particular tables. I would check your ODBC source and your data to ensure that no truncation is taking place on those particular tables.