The Definitive Guide on Collaboration in Power BI. Tutorial on Groups, Sharing, Coauthoring and Content Packs.

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 Added Formatting to Q&A so I wrote a quick Power Q&A Tutorial

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

Power BI Tutorial: How to Parameterize Connection Variables in Power Query

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 BI Tutorial: How to implement Currency Conversion Using Power Query and Power Pivot

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

Power BI Tutorial: Many to Many Relationship using Power BI Designer

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