Forum Discussion
Solved
CLR type
Hello I have a problem with the display of time type data. This is an OLE DB connection to an HFSQL database (windev). The error message I get when I try to view the data on power query is " 'We do n...
Most connectors for SQL style databases allow you to specify a "native query" when you create the connection.
For SQL Server the field is "SQL Statement".
Alternatively you can implement your SQL logic in a view at the data source, and then in Power BI you can consume the view as if it were a table.
In the connection settings you can already specify a custom query.
in this case i want to use the table "pointage " already existing.
What custom query can i use for changing perhaps for casting values?
That depends on the SQL flavor used by your data source.