Forum Discussion
Fields pulling through to Excel incorrectly
Yes, only explicit measures will pull through to Excel.
See here for more detail on implicit vs explicit measures:
https://radacad.com/explicit-vs-implicit-dax-measures-in-power-bi
On a second look, it appears that the only items I can use as values are measures in the dataset.
Yes, only explicit measures will pull through to Excel.
See here for more detail on implicit vs explicit measures:
https://radacad.com/explicit-vs-implicit-dax-measures-in-power-biThanks, that is v helpful. Is there a way in excel to create explicit measures? Or do I have to create the explicit measures in PBI before connecting to the dataset in Excel. It feels a bit messy creating a measure for something which doesn't need a measure in PBI.
It doesn't seem like it.
- Excel PivotTables don't support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures.
From these documentation sources:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel