DirectQuery Connection in Power BI; How does it work? Limitations and Advantages

In the last post, you learned about Import Data or Scheduled Refresh as a connection type. In this post, you’ll learn about the second type of connection named; DirectQuery. This type of connection is only supported by a limited number of data sources, and mainly targets systems with a huge amount of data. DirectQuery is ...

Read More

Connection Types in Power BI: Import Data or Scheduled Refresh; A Detailed Look Inside and Out

Power BI is one of the BI tools in the market that supports more than one type of connection. Each connection type has pros and cons. In this section, we are going to cover everything about Import Data or Scheduled Refresh type of connection. You will learn briefly how Power BI stores data into xVelociy ...

Read More

SlopChart RViz: Power BI Custom Visual

Posted by on Dec 14, 2017 in RVIZ | No Comments

SlopChartRViz SlopChartViz is a custom visual for showing the trend between two times.  There is a possibility to zoom in an zoom out in this chart. This custom visual needs: 1-      First Variable: a group (categorical variable) 2-      Second Variable: Value related to first time 3-      Third Variable: Value related to the second time To ...

Read More

TblChart RViz: Power BI R Custom Visual

Posted by on Dec 14, 2017 in RVIZ | No Comments

TblChartRViz TblChartRViz is a custom visual for showing five variables in one chart. There is a possibility to zoom in and zoom out on this chart. This custom visual needs: 1-      X-axis as the first variable 2-      Y-axis as the second  variable 3-      Color (categorize variable) for the Third axis, which is a legend 4-      ...

Read More

Scatter RViz: Power BI R Custom Visual

Posted by on Dec 14, 2017 in RVIZ | No Comments

ScatterRViz ScatterRViz is a custom visual for showing three variables in one chart. There is a possibility to zoom in and zoom out on the chart. This custom visual needs 1-      X-axis as the first variable 2-      Y-axis as the second  variable 3-      Color (categorize variable) for the third axis To use this chart, you ...

Read More

List.Accumulate Hidden Gem of Power Query List Functions in Power BI

There are a number of List transformations available in Power Query’s graphical interface. However, the number of functions in the graphical interface is very limited. In this post, I’m going to explain about a function that is really powerful and is not yet listed in the graphical interface. List.Accumulate is a function that loops through ...

Read More