Freitag, 12. Februar 2016

Case sensitivity: Power Query vs. Power Pivot

Power Query and Power Pivot are great companions. What ever you want to import and shape… Power Query can make it and Power Pivot builds the models you need to create amazing data insights.


Following that way all the tables of my models come into Power Pivot using Power Query. Take a look at the following simple structured table:




This table shows revenue per customer and date. What I usually do, when I get this kind of table, I import it twice with Power Query.


Donnerstag, 4. Februar 2016

Power BI... Push to Web

Since Microsoft realesed one of the most requested features of Power BI - called Publish to Web - Twitter and respective blogs are going crazy. And I can say, that they are right doing so.

Publish to web is nothing less than the ability to take one of your created reports from your personal powerbi.com site and convert it into HTML-Code (iFrame), which you can implement into your blog, your website, into Sharepoint, etc. The really crazy thing about it is, that it is not an inflexible picture, but it keeps the connection to your powerbi.com site and the original data. So all the time the data in your data model change, the report in your blog (or where ever) also gets updated.

Here is an example for the Power BI User Group Hamburg. Now its only example data, because our first meeting will come in the middle of February. The underlying data comes from an Excel file, which I import into a local Power BI Desktop File. Here I created the data model, some measures and the report, which is shown below. All the time I re-publish my model from Power BI Desktop to powerbi.com this report below gets updated too. It can take about an hour until you see the new data there, but it's simply amazing :)




You can find a video, which describes how to use 'Publish to web' here.

Have fun copying your reports where ever you want.

See you,
Lars