Forum Discussion

ScottR-MT's avatar
ScottR-MT
Icon for Helper I rankHelper I
7 years ago

Analyze in Excel giving error when trying to add fields to pivot

Hi,   When using the Analyze in Excel feature from the PBI service, I generate the .odc file and open it.  Once the file opens in Excel, it creates the connection and generates all of the fields fr...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi ScottR-MT 

What is your data source? Could you please help to post sample data of your table?

When you "add any field to the pivot", Is the data in pivot table and data you are adding from the same table?

 

Best Regards
Maggie

ScottR-MT's avatar
ScottR-MT
Icon for Helper I rankHelper I
7 years ago

Hi Maggie,

 

I am unable to add any fields, so the pivot remains blank.