Forum Discussion
Helper IIIAnalyze in Excel - Can't select "Value"
Hi,
I am now trying to connect the dataset in Power BI Service through Excel. However, when I try to drag and drop the "Value" field into "Values" field under "PivotTable Fields", it don't allow me to do it. Anyone know how to solve it? Thank you.
Hi KH_Mike ,
You had received this message as below:
Because Excel connect a model in the power bi service. There is no data on-premises. One way to solve it.
- Add a measure to the model in service. (use power bi desktop create a measure and republish.
Troubleshooting Analyze in Excel in Power BI Desktop - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
KH_Mike , is it allowing you to drag any other field. Specially aggregated field/measures
- v-chenwuz-msft
Community Support
Hi KH_Mike ,
You had received this message as below:
Because Excel connect a model in the power bi service. There is no data on-premises. One way to solve it.
- Add a measure to the model in service. (use power bi desktop create a measure and republish.
Troubleshooting Analyze in Excel in Power BI Desktop - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
