TechNet Guru Contributions - SQL BI and Power BI
This article lists all articles that participated in the TechNet Guru Contributions SQL Server Reporting Services, Power View, & SQL Server Integration Services category.
2016
September 2016
2015
July 2015
- SQL Server Analysis Service Performance Improvement
- SQL Server: Best way to add additional parent child attribute
2014
October 2014
- Random SSRS Musings 1 : Rowset Concatenation Using Native SSRS Expressions by Visakh16 - Gold medal winner
- Dates in Excel files rendered from reports are displayed as plain numbers by Jan D'Hondt - Silver Medal
- Integrating Power View with SharePoint Server 2010/2013 - Multidimensional Mode by Anushka Weerakkodyge - Bronze medal winner
- Make a dynamic selection from SharePoint list data with the SSIS 2012 OData Source by Jan D'Hondt
- Error occurred while the attribute of the dimension from the database was being processed–snowflake dimension by Jan D'Hondt
September 2014
- Finding SSIS Packages having References to a Table or Column by Visakh16 - **Gold **medal winner
- SSIS: Export Multiple File With Fixed Size by Ch. Rajen Singh **- Silver **Medal
- Power BI Community Council by **Ed Price - MSFT - Bronze **medal winner
- How to show Measure values as either 0 or NULL in Cube? by Anil Maharjan
- Adding Custom Formats Within Textbox Data by visakh16
August 2014
- Import SSIS2012 Project From Catalog Using T-SQL Script by Visakh16 - **Gold **medal winner
- SSIS 2012 new REPLACENULL function by Jan D'Hondt - Silver Medal
July 2014
- Getting Started with Forecasting and Hindcasting in Power View by Firdous S -MSFT - Gold medal winner
June 2014
- Using Power Query to tell your story form your Facebook Data by Anil Maharjan - Gold medal winner
- SSRS Expressions: Part 1 - Program Flow by - Silver Medal
- How to Schedule and Automate backups of all the SSAS catalogs within the Server Instance by Anil Maharjan - BronzeMedal
May 2014
- SSIS - Event Handling with "OnError" or "OnTaskFailed" by Durval Ramos - Gold medal winner
- Expansion of Time dimension in Analysis Service by S Kamath - **Silver **Medal
- SSAS – Ignore unrelated dimension or not by Sherry Li - BronzeMedal
April 2014
- Creating friendly week names in Power Pivot and SSAS Tabular models with DAX by Michael Amadi - Gold medal winner
- Power Pivot DAX: SUMX - Application on Price and Quantity Effect Analysis by TC0098
- Hide/Unhide a Measure irrespective of 'IgnoreUnrelatedDimensions' Property of its Measure Group by S Kamath
March 2014
- A Practical Example of How to Apply Power Query Data Transformations on Structured and Unstructured Datasets by Michael Amadi - Gold medal winner
February 2014
- Geocoding by HimanshuSharma - Gold medal winner
- The Devil is in the Details by Tim Pacl - Silver medal winner
January 2014
- Consume Web-Service via a SSIS Script Component by AB82 - Bronze medal winner
- Power Pivot: Dynamic Filtering Using Slicers Post Convert to Formulas by AB82 - Silver medal winner
- Power Pivot: Casting DateTime to Date in SQL Server Source Query by Paras Doshi
- How to generate XML files in SSIS for each row of a SQL table without any custom code (No script task) by Firdous S- Gold medal winner
- How to generate incrementing numbers in SSIS using script component by Sqlsaga
- Reporting Services: Dynamic zoom for maps in Reporting Services 2008 R2 by AndrewBorgCardona
- SSRS: Working with Tablixes by Tim Pacl
2013
December 2013
- A practical example of how to handle simple many to many relationships in Power Pivot/SSAS Tabular models by Michael Amadi - Silver medal winner
- Execute SSIS 2012 package with parameters via .Net by SSISJoost
- Functional Reports: Making a Report Into a Management Tool by Tim Pacl - Gold medal winner
- Populate Excel table with custom MDX query & PivotTable filters by Christian Wade
- SSAS time dimension with semi-additive measures; dynamic set; calculated members by Minnie Shi
- SSRS - Dependent Parameter and Wild Search in Parameter by Rishab Sachdeva
- Using parameters and variables in a Script Task by SSISJoost
- Using parameters and variables in a Script Component by SSISJoost
- Using a Date Picker for an Analysis Data Query Parameter by Tim Pacl - Bronze medal winner
November 2013
- Calculating the % difference between the same measure evaluated in two user selected contexts by Michael Amadi - Bronze medal winner
- How to add JPEG and PNG report export when SSRS 2012 is integrated with SP 2013 by johnsom - Gold medal winner
- MDX CurrentMember and DAX HASONEVALUE by Christian Wade
- SSRS: Chaining Parameters by Tim Pacl
- SSRS: Converting Between Tablix Controls (Matrix, Table List) by Tim Pacl - Silver medal winner
October 2013
- DAX ISCROSSFILTERED function performance vs. DAX HASONEVALUE function by Christian Wade
- Exists v.s Existing and Auto Exist in MDX by MNisharMSDN - Silver medal winner
- SSRS - How to calculate total of dynamic columns by SathyanarrayananS
- SSRS - Sorting by SathyanarrayananS - Bronze medal winner
- Using a View to Mask Multi-Server SSIS Package Configurations by Jason Brugger - Gold medal winner
September 2013
SQL Server Analysis Services
- SSAS: Custom MDX Query for Excel Filters by ShankarGS - Bronze medal winner
- PowerPivot: Query Power Pivot DMV's with VBA by Olaf Helper - Gold medal winner
- Profile MDX & SQL queries from SSRS by MnisharMSDN - Silver medal winner
SQL Server Reporting Services, Power View, & SQL Server Integration Services
- SSRS (Matrix) - How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling by SathyanarrayananS - Bronze medal winner
- SSRS - RDL Compare by SathyanarrayananS - Silver medal winner
- SSIS - Import Excel to table - Cannot convert between unicode and non-unicode string data types by SathyanarrayananS
- SSRS - Multi-valued Parameter as Stored procedure Input by SathyanarrayananS - Gold medal winner
- SSIS - Lineage ID SSIS by Yogish Bhat
August 2013
SQL Server Reporting Services, Power View, & SQL Server Integration Services
- SSRS: Multiple Ways to Split a String into Multiple Lines** **by SathyanarrayananS *** **- **Bronze **medal winner
- SSIS - Move Folder from one Drive to Another Drive Using File System Task by** SathyanarrayananS ***
- SSIS - How to Add Missing Control Flow Items / Data Flow Items to the SSIS Toolbox by** SathyanarrayananS ***
- SSIS - Flat File Source - Datetime Column Format - Issue & Solution by Rajkumar5055 - Gold medal winner
- SSRS - How to repeat headers for each group by SathyanarrayananS
- SSRS: How to Group Same Row Data with One Column Having Varying Data by SathyanarrayananS
- SSRS - How to set Column Visibility property for many columns based on Parameter value by SathyanarrayananS - Silver medal winner
- SSRS - How to display multiple columns (header and value) horizontally stacked in one row cell by SathyanarrayananS
- SSRS: How to Repeat Headers on Each Page by SathyanarrayananS
July 2013
SQL Server Analysis Services
- Custom Calculations for Invoice & Returns using PowerPivot DAX formula** **by Paras Doshi - Bronze medal winner
- Currency Conversion in SSAS 2012 (Multidimensional & Tabular) by Christian Wade - Silver medal winner
- SSAS Tabular Models: The Good, the Bad, the Ugly and the Beautiful by Paul Turley
- We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced by Paul Turley - Gold medal winner
SQL Server Reporting Services, Power View, & SQL Server Integration Services
- How to Transfer Records from SQL Server to Postgres** **by Shanky_621 - Silver medal winner
- SSRS - Multi Font Color / Multi Font Size within Single Field / Textbox by SathyanarrayananS - Gold medal winner
June 2013
SQL Server Analysis Services
- Aggregations in SSAS By Yogish Bhat
- Gold medal winner - MOD Function in MDX By Yogish Bhat - Silver medal winner
SQL Server Reporting Services/Power View
- Adding Links in SSRS Reports by Tim Pacl - Silver medal winner
- Concatenating Data Column Values Into a Single String by Tim Pacl - **Bronze **medal winner
- Counting Occurrences in a Concatenated String by Tim Pacl
- Preset Date Parameters by Tim Pacl
- Setting Subreport Visibility From User Input by Tim Pacl
- Sorting Elements of a Concatenated String by Tim Pacl - Gold medal winner
See Also
- [[TechNet Guru Contributions]]
- [[SQL Server 2012]]
- SQL Server Integration Services Portal
- SQL Server Reporting Services Portal
- List of Award Winning TechNet Guru Articles
- TechNet Guru - All Gold Winner Contributions
- TechNet Guru - All Silver Winner Contributions
- TechNet Guru - All Bronze Winner Contributions