Month: August 2014

Teradata, DB2, Folder and Many Others Now Supported via Power Query in Power BI Gateway

This is a biggie… a great number of new data sources is now supported for data refresh via a Power BI Gateway. Please follow this link for details. SAP Business Objects is not yet supported. I am particularly impressed with ability to refresh from folder (please note, only CSV files are supported, a folder full

Continue reading
No comments

Bing vs. Google

This is an off-topic post that will not talk about BI at all. Yesterday, I wrote a quick post about using the Earlier() DAX function to generate an index column in Power Pivot. There is nothing earthshattering in that post; the reason I decided to write it was because I tried to do a web search on

Continue reading

Adding an Index Column to a Power Pivot Model using EARLIER() DAX Function

This post will be a little bit atypical compared to what I normally write about. I usually don’t focus on topics like the one described below because there are plenty of other blogs that cover developer specific issues related to using DAX. However, I ran into an issue few days ago, could not find a

Continue reading