QUERY ODBC data source - only import data WHERE condition is true

[dgwilson]

Good afternoon everyone.

I'm new to Power BI and have been making good progress.

I've got a challenge that I've been struggling with for hours to solve and searching for answers hasn't gone so well.

In the Advanced Editor I have the following:

-- BEGIN

let
Source = Odbc.DataSource("dsn=EDW_64", [HierarchicalNavigation=true]),
EDWP_D2PM_Schema = Source{[Name="EDWP_D2PM",Kind="Schema"]}[Data],
SD_ITSM_PROBLEMS_VW_View = EDWP_D2PM_Schema{[Name="SD_ITSM_PROBLEMS_VW",Kind="View"]}[Data]
in
SD_ITSM_PROBLEMS_VW_View

-- END

What I want to do is import data from the table SD_ITSM_PROBLEMS_VW where DELETE_FLAG = 'C'

I don't know if it can be done. And if it can I haven't been able to figure out how.

I've tried to replace [DATA] with [QUERY=....] and that gave syntax errors on the =.

This query will be used through a gateway and thus also reduce the amount of data coming through. The reduced data will also mean that I will not need to add filters to every visualisation!

- David

[v-ljerr-msft · Accepted solution]

Hi @dgwilson,

If I understand you correctly, you should be able to use the SQL statement option to import the ODBC data in your scenario. 

SELECT * FROM SD_ITSM_PROBLEMS_VW WHERE DELETE_FLAG = 'C'

Regards

[dgwilson]

This gives me an error.

Though based on this I think I may need to specify some additional parameters (like database name) before the table. I will experiment. Syntax may be a bit of guess work.

[dgwilson]

This seems to have solved it.

Note the <database name>.<table name> syntax.

Really appreciated your assistance and guidance. Thank you.

[v-ljerr-msft]

Hi @dgwilson,

Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread? 

Regards