Forum Discussion
CLR type
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.
I don't know how PCSoft.HFSQL works. Something like
SELECT CAST([HEUREARRIVEE] as text) from POINTAGE
thank you for the beginning of track. I will test that and continue to look the solution. I will come back to you if this did not ^pass
Thx you i will try that and i will let you know! thx
Hi,Elage,
have you solve this issue? Have the same trouble unfortunatelly
nop unfortunatly. i was forced to export in excel for using the colums in the table
You know, my story has ended succesfully
