Forum Discussion

LizJ's avatar
LizJ
New Member
2 years ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

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

  • Jonvoge's avatar
    Jonvoge
    2 years ago

    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

LizJ's avatar
LizJ
New Member
2 years ago

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's avatar
lbendlin
Super User
2 years ago

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