Developer Support

Advocacy and Innovation

PowerBI - Developer Support

Innovation at your fingertips

January 12, 2018 Jan 12, 2018 01/12/18
Developer Support
In this post, App Dev Manager Adlène Sifi demonstrates innovation at your fingertips by building a real-time earthquake reporting system using Power BI and without writing any code.  You can view a French version of this article on LinkedIn. Innovation usually involves ideation, rapid prototyping, validation with users, measurement (...

Power BI–A case study to end homelessness

February 10, 2017 Feb 10, 2017 02/10/17
Developer Support
Keith Anderson, Senior ADM, shares a practical example of how Power BI quickly transformed a project using simple, out-of-the-box features to integrate data and provide visualizations. I had the opportunity recently to work with the Connecticut Coalition to End Homelessness (CCEH) on their yearly Youth Point-in-time (PIT) Count event.  ...

Transpose Data Based on Repeating Pattern in a Column in Power Query

January 26, 2017 Jan 26, 2017 01/26/17
Developer Support
Senior Application Development Manager, Robert Reilly, walks us through an approach to transpose data based on repeating patterns in Power Query. (image) You may run into a scenario where you receive data in say a CSV that needs to be transposed (Row become Columns).  If you want to transpose a table it's pretty straight forward in Power ...

Parsing folders in Power BI and adding the folder name as a column in the Power Query

January 11, 2017 Jan 11, 2017 01/11/17
Developer Support
Senior Application Development Manager, Robert Reilly, walks us through parsing multiple files contained in multiple folders from Power BI. (image) On occasion you may have a need to parse multiple files contained in multiple folders from Power BI.  As an example I am working with a colleague to generate some Power BI reports from CSV data...

Loading paged and related data from MS Graph API into Power BI using a recursive Power Query function

October 7, 2016 Oct 7, 2016 10/7/16
Developer Support
Senior Application Development Manager, Robert Reilly, recently came upon a situation where he needed to provide enhanced, adhoc, and drillable reporting based on a mix of data sources.  Leveraging Microsoft Graph API for customer data and using Power BI, he explores the power of using these technologies together to build a solution and ...