Not Folding; the Black Hole of Power Query Performance

Have you ever thought does your Power Query Transformations happens in the data source side (server side), or on the local memory (client side)? When you use a relational data source, query can be run on the data source, but it depends on transformations. Some transformations can be translated to query language of the data ...

Read More

PASS Summit 2016 – Day 2 Keynote

Posted by on Oct 28, 2016 in Uncategorized | No Comments

PASS Summit Day 2 started with Keynote of Dr. Dewitt from MIT. I personally am so exited to hear this keynote. Sitting again on blogger’s table will write highlights of today’s keynote here in this post. Please refresh this post to get updated information. 8:18 – Grant Fritchey stepped up in stage 8:21 – Over ...

Read More

PASS Summit 2016 – Day 1 Keynote

Posted by on Oct 27, 2016 in Uncategorized | No Comments

PASS Summit 2016 started Monday 24th of October 2016 with some pre-cons on day one and day two. The third date which is Wednesday 26th of October 2016 is the regular conference start day and for today the first keynote is with Joseph Sirosh Microsoft CVP of Machine Learning and Data Platform. I am sitting ...

Read More

Dashboard vs Report; Differences At a Glance – Power BI

This question is one of the main questions that people ask when they are at the preliminary stages of building a Power BI solutions. There is a misconception that Report is a detailed tabular report, and dashboard is interactive visualizations with chart. However this definition isn’t what Power BI reports and dashboards stands for. There ...

Read More

Loop Through On-Premises Files with Power BI and Schedule it to Refresh Automatically

Previously I’ve explained a method of looping through number of files in a folder which used Custom Functions. This method is preferred method buy not always working with Schedule Refresh and gateway setup, because scheduled refresh doesn’t always support custom functions in the code. So I this post I show you a second method that ...

Read More