Incremental refresh using PowerBI pro and Dataflows
In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI pro version.
PowerQuery
EU Countries Inflation rates since 2005 [PowerBI interactive Dashboard]
The Internet is full of valuable online free sources which, if used correctly, can bring great incremental value to company employees. One of those sources is Eurostat, the statistical office of the European Union. On the official pages of Eurostat, you are able to pull pretty much any statistical data about the Macroeconomic environment of …
EU Countries Inflation rates since 2005 [PowerBI interactive Dashboard] Read More »
The next generation of data analysts
So far I have written a couple of articles about PowerPivot, PowerQuery, and DAX. The reason I started my blog with these topics, and will continue to do so, was to get you all familiar with “New” technologies that are coming our way and that are redefining our understanding of Data extrapolation and data analysis. …
Power Query – Powerful Excel feature you should start using right away
Power Query, or Get&Transform in Excel 2016, is an ultimate tool for data transformation before loading it to Excel/Power BI. PowerQuery stands as a mediator between different data sources (Databases, Excel files, Web sources…) and final input. We can say that it acts like a macro recorder, but instead of recording movement across sheets, it …
Power Query – Powerful Excel feature you should start using right away Read More »
