Lessons Learned from Unpacking VertiPaq: A Developer’s JourneyVertiPaq is the powerhouse behind Microsoft’s in-memory column store technologies that power memory structures from PowerPivot in Excel and…May 15May 15
Closures, metadata and cascading parametersIf you’re interested in cascading parameters and Power BI custom connectors is an option for your project, you should give a try to…Oct 14, 2017Oct 14, 2017
Exposing #shared in Azure Analysis ServicesWhile I enjoy that now I can write PowerQuery expressions everywhere in Analysis Services, the fact that I don’t know what is available at…Aug 16, 2017Aug 16, 2017
Drawing Homer Simpson with DAX trigonometric functionsRecently I started exploring the limits of standard charts in Power BI and ended up drawing all sorts of mathematical functions. For the…Jun 9, 2017Jun 9, 2017
Navigating over 600+ M funcitonsWhenever I’m faced with a data mashup problem in Power BI, I try to check if it can be resolved with a standard M functions exposed by the…May 1, 2017May 1, 2017
Exporting Power Query tables to SQL ServerPower Query is a great tool for data mashup, however when it comes to really show its powers as a desktop ETL tool, you realise that no…Apr 4, 2017Apr 4, 2017
4 ways to get USERNAME in Power QueryRegardless of what are you requirements, be that providing some user context during slicing of data or a filtering mechanism for data…Apr 3, 2017Apr 3, 2017
Extracting Power QueriesTL;DR Another place to find your Power BI queries is in the data sources of the embedded tabular model. They are stored in a zip file…Mar 22, 2017Mar 22, 2017
R, Power Query and msmdsrv.exe port numberThe quest to fetch the details of the ever evasive $Embedded$ connection to the local tabular data model has always interested the Power…Mar 13, 2017Mar 13, 2017
R.Execute() the Swiss Army knife of Power QueryI rarely use in Power BI, but when I do, I make sure to keep the data mashup out of it. I don’t have anything against R, it’s arguably the…Mar 11, 2017Mar 11, 2017