Well, not really that definitive actually… Before we jump into the details, I have to admit that I fully expect this post get outdated very soon. The collaboration features that have been released with GA of PowerBI 2.0 on July 24th 2015 are still not very refined and are very likely to become much more … Continue reading The Definitive Guide on Collaboration in Power BI. Tutorial on Groups, Sharing, Coauthoring and Content Packs.
Microsoft Power BI team has released a lot of new features to http://app.powerbi.com including lots of formatting enhancements for Q&A (please follow this link for additional details http://blogs.msdn.com/b/powerbi/archive/2015/07/15/new-capabilities-added-to-power-bi.aspx ) In this post I wanted to show you how you might get started on Power Q&A using the Retail Analysis Sample that is currently available in … Continue reading Microsoft Added Formatting to Q&A so I wrote a quick Power Q&A Tutorial
It's common that data is laid out across columns in Excel for reporting purposes. E.g. Revenue for each product is laid out across the columns in excel for each month. However this may not work well as a data source. Power Query provides Unpivot option to solve this issue. Sample workbook can be downloaded here. … Continue reading Power BI Tutorial: UnPivot Feature
While migrating a power query solution across environments (Dev to UAT to Prod) changing connection variables for each power query is a tedious task. Here is a way to make the connection variable dynamic. The sample here has two power queries connecting to SQL server source. Create an excel table and call it Parameter with … Continue reading Power BI Tutorial: How to Parameterize Connection Variables in Power Query
Power Query has a feature that can be used to drill into details. This is particularly useful when working with 32 bit excel. Sample workbook can be downloaded here. Here are the steps. For the purposes on the tutorial let's load Sales data from an excel table (this could be from a database). Highlight Sales … Continue reading Power BI Tutorial: Drill into Details
Data for the tutorial can be obtained by downloading the following files: Exchange Rate File Working with Currency File Step 1: Load Sales Data to Data Model Open workingwithcurrency.xlsx, highlight Sales Data table, pick PowerPivot from the ribbon and select Add to Data Model Step 2: Using Power Query to transform Exchange Rate data … Continue reading Power BI Tutorial: How to implement Currency Conversion Using Power Query and Power Pivot
Quick disclaimer, the Power BI Designer is in preview right now and as such it is lacking a number of very important features that some consider minimally necessary for the product to be usable (a few thoughts on where the product is in its current state from my perspective could be found here). At the … Continue reading Power BI Tutorial: Many to Many Relationship using Power BI Designer