Forum Discussion

LFM's avatar
LFM
Helper III
2 years ago

Issues with getting data from PBI to excel

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?

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • LFM's avatar
    LFM
    Helper III
    2 years ago

    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's avatar
    tharunkumarRTK
    Super User
    2 years ago

    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!