Forum Discussion
Solved
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,0...
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
What is your expected outcome? What are you planning to do with the extracted data?