Latest Enterprise DNA Initiatives

Can't create Pivot Table in Analyze in Excel from .pbix published to the Service

Hello EDNA Forum Good Day!

I can’t seen to move Gross Sale into the values section of the pivot table using Analyze in Excel.

Here are the steps I took in Analyze in Excel

I published the .pbix to the service, select Analyze in Excel, then downloaded file to my machine. When trying to move Gross Sales into the value section of the pivot table I received the following error message.

My .pbix
I was able to create the pivot table in my .pbix…screen shot below.

Much appreciate your help!
Thank you

Sample Financial Data Analyze in Excel.pbix (206.0 KB)

Hi @ambidextrousmentally,

In your example you are only using implicit measures, is that also the case in your production file? If so, create explicit measures for all these numerical fields and hide those columns in the model.

I hope this is helpful.


Hi @ambidextrousmentally, did the response provided by @Melissa help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

Hello Melissa

Great video, just what I needed to better understand Analyze in Excel and the use of Explicit and Implicit measures in Power BI.

Much appreciate your help!

Thank you