Issues with getting data from PBI to excel

[LFM]

Hello. Im having some issues with getting data to a excel file where I use pivot table, from a Power BI report. There are some of the fields I cannot get the data from, and I get an error message as shown below. What could be the issue and is it some way to fix it?

[LFM]

Hello. Im having some issues with getting data to a excel file where I use pivot table, from a Power BI report. There are some of the fields I cannot get the data from, and I get an error message as shown below. What could be the issue and is it some way to fix it?

[tharunkumarRTK]

@LFM  

Det ble oppgitt en tabell med flere verdier der én enkelt verdi var ventet.

A table with several values ​​was given where a single value was expected.

I guess you got this error message when you puled a DAX Measure into a pivot table.  Open the report in power bi desktop and check if there are any errors, Make sure the measure is resulting in only one scalar value. or share the pbix file here

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!