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.
That depends on the SQL flavor used by your data source.
What do you need right now for helping?
what do i do for giving you the SQL flavor?
i have this in this window. What do we write on the custom query?
I don't know how PCSoft.HFSQL works. Something like
SELECT CAST([HEUREARRIVEE] as text) from POINTAGE
Thx you i will try that and i will let you know! thx
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
Bonjour,
toujours dans la méme optique . Ayant un fichier .sql , comment faire pour l'intégrer dans power query. Le but c'est de voir s'il va pouvoir enlever la "complexité" des colonnes de la base initiale en des colonnes de type heure simple et exploitable dans power queryMost 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.
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
