Enter a SQL Query by connecting to a .sql file instead of explicitly typing the SQL. This option would allow a developer the ability to maintain their SQL code in one place (instead of in Power Qu...
luke_beacon
6 years agoNew Member
For the record, anyone curious about the comment "it is possible with manipulation of M," here is one way it can be done: let SqlSource = Table.FromColumns({Lines.FromBinary(File.Contents("C:\Users\user\ExtractQuery_ForPowerBI.sql"), null, null, 1252)}), #"Transposed Table" = Table.Transpose(SqlSource), #"Merged Columns" = Table.CombineColumns(#"Transposed Table",Table.ColumnNames(#"Transposed Table"),Combiner.CombineTextByDelimiter("#(lf)", QuoteStyle.None),"Query"), Source = Sql.Database("server_name_here", "database_name_here", [Query=#"Merged Columns"{0}[Query], CreateNavigationProperties=false]) in Source This works by transposing the rows (since reading a file source brings a well formatted query in as multiple rows), merges them with a linebreak as the delimiter (to avoid issues with comments ruining the code when all on one line), then uses that value as the query source.
Recent ideas
Dynamic Labels for Subtotals and Totals in Power BI Matrices
Power BI should support dynamic expressions for subtotal and total labels in Matrix visuals. Currently, subtotal labels are static, which limits report usability and forces report authors to implemen...KellyMc2 hours agoNew MemberNew3Views0likes0CommentsCustom page navigation and foldable menus with less bookmarks (modern web UI inspired)
I recently watched a lot tutorials on how to achieve page navigations as common in modern web frameworks as Bootstrap including foldable site menusbars and dropdown menus. Or building toggle buttons....Famondir3 hours agoNew MemberNew96Views1like1CommentNavigation page - create custom sections and heirarchy
Please can you bring back this feature? https://powerbi.microsoft.com/en-us/blog/designing-custom-navigation-for-power-bi-apps-is-now-available/ We have many reports in our app, and would like ...anna_schorfield3 hours agoNew MemberNew109Views1like2Comments