When connecting to a live data source (Direct Query Mode) and using the "Analyze with Excel" the numeric values that are present in the data and aggretable in Power BI's interface can not be used in Excel to aggregate, which makes this feature uselss as a pivot table.
Is there a workaround other than Importing the Data and creating measures. Power BI only has a 10G limit on data!
@rayishome Numerics and aggregates present in your data source cannot be used in Excel to aggregate even when you Import data in power bi. That is standard in Pivot Table. You need to explicitly create measures in order to use them as aggregates in Pivot Table. Connecting via DirectQuery will still allow you to create measures in power bi desktop and once report is published you can use those measures under Values section in Pivot Table.
@rayishome really, I haven't came across that before. I have used directquery to sql server, created measures in desktop, published to service and use analyze in excel. What is your data source ? And where does it delete it. Do you see them appearing in power bi service ?