Allow Power Query results to be written back to a flat file or SQL table. Relivant forum thread: http://community.powerbi.com/t5/Integrations-with-Files-and/Can-PowerQuery-write-data-back-out/m-p/1...
redgumbusinesss
6 years agoNew Member
You can do this with a small amount of VBA and a calculated column that incorporates an INSERT statement. Load the data into an Excel worksheet then iterate down each row executing the INSERT statement. Would be good if you could specify a database and table as a destination though! ;)
Recent ideas
Power BI: Don't auto-SUM numeric data types
When setting column data type to numeric, Power BI defaults to automatically summing those columns. In real-world data most numeric data columns are not meant to be summed. They are sometimes primary...SevsBo1 hour agoResponsive ResidentNew3Views0likes0CommentsPower BI: keep Transform button visible during initial data load, not hidden under Load button
With regular data ingestion it would be great if the Transform Data button wasn't hidden under the Load button. Any experienced Power BI developer will first do a data transformation, not merely load...SevsBo1 hour agoResponsive ResidentNew3Views0likes0CommentsCase sensitive-insensitive option in Power BI
There should be an option in Power BI for the data in the columns to be either case sensitive or insensitive. When one deals with data involving client names or entity names, case sensitivity-sinsens...sohail_syed_moh1 hour agoNew MemberNeeds Votes2.3KViews127likes12Comments