Forum Discussion

trebgatte's avatar
trebgatte
Icon for Most Valuable Professional rankMost Valuable Professional
10 years ago

Analyze in Excel oddity

I'm wondering if anyone else is struggling with this. I've got numeric values in my dataset that are defined as decimal and default behavior is to sum. Works well in Power BI.   If I connect to the...
Need Help
rayishome's avatar
rayishome
Icon for Resolver I rankResolver I
10 years ago

What about Direct Query Mode, it doesn't appear you can add Measures? 

  • trebgatte's avatar
    trebgatte
    Icon for Most Valuable Professional rankMost Valuable Professional
    10 years ago

    As Matt says, it's a limitation. I'm going against all OData data sources in my case.

     

    Treb Gatte, Power BI Red Carpet Partner | Microsoft MVP | Twitter | Blog | Blog 2

     

  • rayishome's avatar
    rayishome
    Icon for Resolver I rankResolver I
    10 years ago
    Given the lack of support for measures and the current design what can the analyze in excel on a direct query be used for?