Forum Discussion
Understanding how Power BI Desktop Filters work
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.
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).
4 Replies
micheledubose , is it a direct query connection?
If yes check the datatype of column, if it is text on source or not
It is a direct query connection. The data type is varchar2.
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?
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).
