Forum Discussion

FatiFlaubert's avatar
FatiFlaubert
Helper I
5 years ago
Solved

Data source update

Hi,   I've transformd my data via Power query by adding new column with a calculation, removing other columns. Now I've added new data to my data source but when I try to refresh my dashboard on Po...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi FatiFlaubert ,

     

    There are duplicate fields in the formula.

     

    Best Regards,

    Yuna

     

FatiFlaubert's avatar
FatiFlaubert
Helper I
5 years ago

Hi Pragati11 

After deleting the column name from the formula bar and trying to save I got this : 

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi FatiFlaubert ,

 

Looks like you have deleted a token within the expression like comma, brackets, etc. along with the column name.

Did you take backup of the previous formula bar value? If not close the pbix file without saving and open it again and then be careful when you remove a column reference from this formula.

 

Or before closing pbix, scroll to the right on the error and see where it is giving error.

 

Thanks,

Pragati