Forum Discussion
Is there a way to write a SQL Query into a TXT file and execute it from PBI?
Dear PBI users, good afternoon. Currently we are analyzing dividing the development team into front-end - UI / UX design (mostly focusing on the PBI charts , UI and overall UX) and Back-end (SQL ...
I managed to apply the same mode in our team last year, i.e. we use PQ to read sql files stored in a centralized sql depository; we are able to compile sql easily.
let // applicable to .txt / .sql files Source = "C:\Users\Home\Downloads\Qry.sql", SqlContent = Text.Combine(Table.ToColumns(Csv.Document(File.Contents(Source))){0}, "#(lf)") in SqlContentSql.Database("server", "database", [Query=SQLContent])
I managed to apply the same mode in our team last year, i.e. we use PQ to read sql files stored in a centralized sql depository; we are able to compile sql easily.
let
// applicable to .txt / .sql files
Source = "C:\Users\Home\Downloads\Qry.sql",
SqlContent = Text.Combine(Table.ToColumns(Csv.Document(File.Contents(Source))){0}, "#(lf)")
in
SqlContentExactly what we want to do , quick question ThxAlot , and how do you execute it?
something like a blank query with
= Sql.Database("server", "view", [Query=SQLContent])?
Sql.Database("server", "database", [Query=SQLContent])Amazing! Just out of curiosity, how was the development after implementing this method? Overall better?