New version of the Power BI designer now supports DAX

As most of you probably have seen or heard, the Power BI designer now supports some of the Power Pivot features like DAX and renaming columns, formatting etc. Some of the features: Formula bar: Using the new formula bar in the Report view you can create measures by writing formulas in the DAX language. The formula bar helps you write these formulas by differentiating functions, fields and measures using syntax coloring, it provides intelligent function... Read more

Sessions at SQLBits

I am very happy to share that I’ll be doing several sessions at the SQLBits conference this year. I will be doing the following sessions: We now have an exciting developer story for Power BI, the session Developing for Power BI I will go into how to write applications for Power BI and show you several examples. Lot’s of code here, from PHP to .Net, JSON and REST and OAuth.. not your average BI session... Read more

Power BI news

You probably have heard the news already but we have some exciting information that has been released on the new Power BI service as you, for all the details read the blog post on Microsoft. Some great new functionality that is being released are: – Dashboards that allow you to gain insights in your data right away. A single pane of glass for all your data. You can mix and match data from several data... Read more

New year and several updates

As most of you have probably noticed I have not been very active recently, this has everything to do with the recently released preview for Power BI that took all my time. Luckily now that we shipped the first preview I hope to be able to spend some time on blogging again, mostly on the amazing new designer when more features come online for that. Right now I am playing with the Power BI API’s in... Read more

Automatically ranged date table using DAX and M

I am prepping some demo’s for my SQLPass summit session “End-to-End Demos with Power BI” where I’ll show many of the tricks I use in my Power BI workbooks. One of them is this trick that I recently figured out, I am so excited about it that I wanted to share it with all of you. I figured out a way to automatically generate a data table with a dynamic range based on the data... Read more

Export a table or DAX query from Power Pivot to CSV using VBA

Had an interesting question today. Someone did some great transformations combining multiple files into a single table and adding some calculations using Power Query and Power Pivot. Now he wanted to load that data into CloudML to do some machine learning on top of this data. Currently cloudML takes csv files so the question was how can I get data from the Power Pivot model into a CSV even when there are more than 1.000.000... Read more

Getting data into Power Query with the twitter search API (how to hack PQ to use OAuth)

Last week I decided to try an interesting experiment. Lets see if I can get data from the Twitter REST API into Power Pivot using Power Query. Power Query already supports two out of three things that are needed for me to import this data: Import from a web url is already supported Parsing JSON data is already supported Logging into the service with OAuth is not supported for a datasource that is not developed... Read more