Atlanta Business Intelligence Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Help from ATL BI Group

    Posted May 15, 2017 11:32 PM
    Atlanta,

    I'm new to the group but looking for some help right off the bat.  A few months ago I realized that Excel's Power Query / Get Data functions were not executing with the same performance as Power BI.  The performance difference can be dramatic (5 min in Excel 2016 vs 9 sec in PBI Desktop with the same data model).

    I added an idea to Excel User Voice (Similar to the PBI ideas website) and looking for some help up voting this idea.  If ya'll have a min I would appreciate the support.

    Thanks and looking forward to joining the next event.

    Josh

    Power Query - cache shared nodes
    UserVoice remove preview
    Power Query - cache shared nodes
    Update Power Query in Excel to take advantage of caching in cases where a parent node refers to a child node that has already been refreshed (as exists in Power BI desktop today). This issue creates significant performance problems with refresh times when creating highly interdependent financial and operational models.
    View this on UserVoice >


    ------------------------------
    Josh Blackman
    Sr. Business Analyst
    470.378.7915
    ------------------------------