Forum Discussion
Values from measures not available in Excel
HI team, I am connecting to Power BI dataset from Excel using the Excel Publisher. I am not not able to see values for some measures in the Pivot table in Excel, while those measures work absolu...
This is a big problem in Excel when connecting to SSAS Tab model that measures are not available in Excel. The workaround is to create calcuated measures then they are available in Power BI and Excel. However, the aggregation is fixed when you create the measure (like SUM, AVG) and you cannot change it in Excel or Power BI. It seems like there is no update from MS on this issue.