Exporting summarized data vs. underlying data

[LizJ]

I have created several table visualizations and was trying to export.  I am not given the option to choose summarized data when I click on the More Options ... in the upper right corner.  The 1,500,000 rows of data is summarized to a table with about 15,000 rows and cross-tab columns of 12 months.  So the underlying data exceeds the 30,000 rows.

I'm using Power BI Desktop downloaded a few months ago..

I went into the settings and have chosen the ability for end users (me) to export summarized data.

[lbendlin · Accepted solution]

Run DAX queries directly from Excel, or use the Analyze in Excel feature for cube access.

[Jonvoge · Accepted solution]

Hi LizJ

Your best option for using tabular data in Excel, is to use "Get Data" inside Excel to connect directly to your semantic model:

This way you can create all the tables you desire based on your centrally maintained Power BI model.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[lbendlin]

What is your expected outcome?  What are you planning to do with the extracted data?

[LizJ]

It is an array of members with spending by month. I would be using it in excel. The real issue is that the option to see a table visualization even a small one isn't coming up. 

[lbendlin · Accepted solution]

Run DAX queries directly from Excel, or use the Analyze in Excel feature for cube access.