SSAS Tabular Pivot Issue

Copper Contributor

When I’m pivoting the Tabular cube in excel on my machine (RAM Size: 16 GB), I’m able to add 4 or 5 Dimensions at row-level and when I try to add more, I’m getting the below error.

"We couldn't get data from an external data source. Please try again later.
If the problem persists, please contact the administrator for the external source.
Here is the error message that was returned from the analysis server named servername"

 

Any suggestions.

Thanks in advance.

0 Replies