Forum Discussion

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 04, 2017

Excel and Power BI – better together

Great new feature (preview) is introduced in Apr update of Power BI Desktop. Now we may connect directly to the dataset published in the Power BI service.   Other words – create and support the dat...
BI & Data Analytics
General Comment
Wyn Hopkins's avatar
Wyn Hopkins
MVP
May 19, 2017

Following on from Yury's email

 

I've now come across several scenarios where RIGHT-CLICK refresh on a Pivot Table doesn't update if the measure isn't stored in the same table as the rows / column labels in the Pivot.

 

This sort of makes sense but is something to be wary of.   

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 20, 2017

Hi Wyn,

 

I agree that could be situations when separate measure isn't updated since re-freshing and re-calculating are different processes in Power Pivot. Especially with right click when you refresh only one conenction, not entire data model. Or when source of data is internal tables in same excel file - when double All refresh could be reqiured.

 

And it depends on how the model anr reports built

 

 

 

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jun 06, 2017
    Good stuff :) I probably got the tip from those guys in the first place !

Resources