Forum Discussion

aanmi's avatar
aanmi
Helper I
10 years ago
Solved

something's wrong with one or more field

Hi everyone   I'm having this error after publish my data to dashboard. Kindly advise how can I fix this error so that I can pin to my report  
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    aanmi have you changed field names or table name in power bi desktop file. to fix this you should delete your service dataset and then re-publish your pbix file.

     

  • SamLester's avatar
    SamLester
    10 years ago

    As Ankit mentioned, there was a change to the underlying data set, which is causing problems. The error message refers to a column named TOTAL SALE, which is not in your data model screenshot. Go into powerbi.com and delete the data set for this project and recreate/republish it.

     

    Thanks,
    Sam Lester (MSFT)

aanmi's avatar
aanmi
Helper I
10 years ago

This is my dummy data used for map visualization. Can you tell me if there's something wrong in my data

SamLester's avatar
SamLester
Microsoft Employee
10 years ago

As Ankit mentioned, there was a change to the underlying data set, which is causing problems. The error message refers to a column named TOTAL SALE, which is not in your data model screenshot. Go into powerbi.com and delete the data set for this project and recreate/republish it.

 

Thanks,
Sam Lester (MSFT)

  • aanmi's avatar
    aanmi
    Helper I
    10 years ago

    Hi

     

    thank you for your expalanation.

    Map now able to display.

    But one thing to concern here is the plotted legend is not same as in PBI Desktop.

     

    Below is design in PBI Desktop (pie chart as legend inside map)

     

    But after publish, map display as below (no pie chart)

     

    Please advise

    Thank You

    • SamLester's avatar
      SamLester
      Microsoft Employee
      10 years ago

      aanmi I would suggest that you start a new thread (and mark the other as answered) since this is a different topic. You will have others more experienced in this specific issue be able help out if the title reflects the new issue.

       

      Thanks,
      Sam Lester (MSFT)