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.
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 query
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.