Understanding how Power BI Desktop Filters work

[micheledubose]

In Power BI Desktop, when using the filter pane, what is the background script that is created? I've created a Power BI report where I want to use the contain condition but I get the following error in my report: OLE DB or ODBC error: ORA-00904: "t1"."mycolumn": invalid identifier; ORA-00904: "t1"."mycolumn": invalid identifier. However, when I use the is condition, my report works. 

Below is how I'm applying the filter.

[micheledubose]

I more so would like to know if there's scripts in the background when creating visuals in Power BI Desktop.  Are these scripts obtainable? 

[DataInsights · Accepted solution]

@micheledubose,

To see the query that is generated for a visual, go to View --> Performance analyzer. Click Start recording, and Refresh visuals. Once the visual has been refreshed, click Stop. Then click Copy query and paste in Notepad++, etc. This query contains both DAX and SQL (for DirectQuery tables).

[amitchandak]

@micheledubose , is it a direct query connection?

If yes check the datatype of column, if it is text on source or not

[micheledubose]

It is a direct query connection.  The data type is varchar2.