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

Jonvoge's avatar
Jonvoge
Most Valuable Professional
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