by Gil Raviv | Sep 11, 2019 | Data Chant
Follow @gilra Since the release of Power BI Template Apps, more than 50 new apps have joined the marketplace. It’s about time we would be able to search for template apps in a new way – in our own Power BI report that can be installed as a Template App – and not just...
by Gil Raviv | Sep 5, 2019 | Data Chant
Yesterday night Power BI Facebook connector started to return errors when used to import public facebook pages. If you are using my Facebook Pages – Basic Analysis template app from AppSource, or have any of my Power BI facebook reports, you will have this error when...
by Gil Raviv | Aug 30, 2019 | Data Chant
Earlier this month my template app Facebook Pages – Basic Analysis was featured here in Microsoft’s official monthly feature summary for Power BI Desktop. I would like to thank the 3,798 users who installed it so far and to Microsoft Power BI team who featured my work...
by Gil Raviv | Jul 31, 2019 | Data Chant
Follow @gilra In the last post here, we walked through the steps to detect overlapping time periods and calculate their durations. We used Cartesian Product to match all the pairs of tasks of the same resource, and even used the M function Table.Buffer to accelerate...
by Gil Raviv | Jul 22, 2019 | Data Chant
Follow @gilra In my last blog post here, I introduced the overlapping time periods challenge and shared the M queries for the solution. In today’s post, we will go through the solution in details. This post first appeared...
by Gil Raviv | Jul 16, 2019 | Data Chant
Follow @gilra In Chapter 11 of my book, I introduced the Cartesian Product technique that enables you to combine two datasets in order to apply a calculation or filtering on each combination of paired records. In this article, you will learn how to apply this...
