Igor CotrutaClosures, 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…4 min read·Oct 14, 2017----
Igor CotrutaExposing #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…2 min read·Aug 16, 2017----
Igor CotrutaDrawing 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…·2 min read·Jun 9, 2017----
Igor CotrutaNavigating 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…3 min read·May 1, 2017----
Igor CotrutaExporting 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…4 min read·Apr 4, 2017----
Igor Cotruta4 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…·4 min read·Apr 3, 2017----
Igor CotrutaExtracting 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…3 min read·Mar 22, 2017----
Igor CotrutaR, 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…2 min read·Mar 13, 2017----
Igor CotrutaR.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…·3 min read·Mar 11, 2017----
Igor CotrutaPower Query matrix multiplicationAlthough matrices are not first class citizens in Power Query, quite often a business problem comes along which might greatly be…2 min read·Feb 24, 2017----