Forum Discussion

SammySam's avatar
SammySam
New Member
2 years ago
Solved

Need help with OBDC filter query error.

Hi, 

 

 

I am new to Power Query and I am trying to load some data using an ODC query. 

 

I am getting the following errors with the below query: 

Expression.Error: The name 'GetList' wasn't recognized. Make sure it's spelled correctly.

 

I have defined 'BP_Selected_ACT' as a named range in my workbook and named range should result in matches.

 

Please can you let me know what you think the issue is?

 

 

let
Source = Odbc.Query("dsn=BusinessModel","

SELECT
DT1.ORGANISATION_SHORT_NAME,
DT1.ACT_MODEL,
DT1.ACT_METRIC_ID,
DT2.ACT_METRIC,
DT1.FISCAL_YEAR
FROM
BusinessModel.MV_ACT_CATEGORISED_METRICS DT1
JOIN
BusinessModel.DIM_ACT_METRICS_ENTITY DT2
ON
DT1.ACT_METRIC_ID = DT2.ACT_METRIC_ID
WHERE
DT1.ORGANISATION_SHORT_NAME
IN
('" & Text.Combine(GetList("BP_Selected_ACT"), "','") & "' )

"),

#"Filtered Rows" = Table.SelectRows(Source, each true)

in
#"Filtered Rows"

  • Anonymous's avatar
    Anonymous
    2 years ago

    Even though it's a named range, you still have to pull it in using Excel.CurrentWorkbook as a query source, and then select the named range. And you can refer to it by its query name 

     

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Even though it's a named range, you still have to pull it in using Excel.CurrentWorkbook as a query source, and then select the named range. And you can refer to it by its query name 

     

    --Nate

    • SammySam's avatar
      SammySam
      New Member

      Thanks - it was because i had not defined the GetList function properly