Forum Discussion
Exporting summarized data vs. underlying data
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.
Run DAX queries directly from Excel, or use the Analyze in Excel feature for cube access.
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
4 Replies
- lbendlin
Super User
What is your expected outcome? What are you planning to do with the extracted data?
- Jonvoge
Most Valuable Professional
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
