Forum Discussion

PeteSmith6730's avatar
PeteSmith6730
Frequent Visitor
8 years ago

Slow Refresh Power Pivot cube formula

Newbie here with a slow spreadsheet refresh issue. I have a powerpivot spreadsheet with a lot of cubevalue and cubeset formula which seems very slow to refresh   Data model is: Fact table - 200,0...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi PeteSmith6730

For question1,2, you have a correct understanding by yourself.

Let us come to the next three questions:

3: I'm afraid applying slicers can't be helpful.

4: you could consider the fuction "Enable load", "Include in Report refresh", reference here.

5: How to change the Dax (or MDX query) which feeds the pivot table should be done, as appropriate.

Generally, you could refer to the DAX reference.

https://msdn.microsoft.com/en-us/query-bi/dax/data-analysis-expressions-dax-reference

 

Best Regards

Maggie

PeteSmith6730's avatar
PeteSmith6730
Frequent Visitor
8 years ago

Thanks for assist Maggie.

I think I may revert to standard excel formulae where poss and see how I go with that.

I may also break the workbook into 3 - 1 for each tab.

 

I looked at your Enable Load link, but this refers to power BI and I'm working in power pivot.

Is there similar functionality in Power Pivot and how do I find it?

 

Assuming I can write the correct DAX (newbie is doubtful!), where do I enter the DAX code to refresh the Pivot table.

I think the refresh is performing one trip to the data model to get the bulk of what I need and then separate trips for each of the cubeset formula. How does Dax look to make one trip?

 

Pete