Forum Discussion
Solved
Fields pulling through to Excel incorrectly
Hi, I'm experimenting with the Get Data from Power BI datasets functionality in excel. I can connect fine to my power bi dataset and I am then given the ability to create a pivot table. So far so...
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
Thanks, 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