Forum Discussion

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
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

Regular Visitor

1 year ago

Thanks all for you reply on this issue.

I checked the privacy level, and everywhere it is set to Organisational setting.

There is no transform step in my query, please see the script from the advanced editor

let
Source = Odbc.DataSource("dsn=Simba Athena", [HierarchicalNavigation=true]),
AwsDataCatalog_Database = Source{[Name="AwsDataCatalog",Kind="Database"]}[Data],
dtl_radius_13_2db05_Schema = AwsDataCatalog_Database{[Name="dtl_radius_13_2db05",Kind="Schema"]}[Data],
pv_jobcosts_Table = dtl_radius_13_2db05_Schema{[Name="pv_jobcosts",Kind="Table"]}[Data],
#"Filtered Rows" = Table.SelectRows(pv_jobcosts_Table, each ([plantcode] = "7") and ([jobcode] = "1000878"))
in
#"Filtered Rows"

Please see the screenshot of the query step