Forum Discussion

damiancds's avatar
damiancds
Frequent Visitor
5 years ago
Solved

Refreshing dataflow error: It's adding M language

I have a simple calendar table dataflow (create a list of dates, add columns based on date). I'll admit I copied some code online and tweaked it for my requirements.   Code: let FromYear = Date.Y...
Dataflow
Need Help
  • damiancds's avatar
    damiancds
    5 years ago

    So, in case anyone stumbles across this in the future:

     

    I was an idiot. At the very end of the code, I had 

     

    #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns3", {"FiscalBaseDate"})
    in
    Source

     

    This is what it needed to be (instead of in Source)

    in

    #"Removed Columns"

     

     

    Once changed it refreshed with no errors.

damiancds's avatar
damiancds
Frequent Visitor
5 years ago

So, in case anyone stumbles across this in the future:

 

I was an idiot. At the very end of the code, I had 

 

#"Removed Columns" = Table.RemoveColumns(#"Renamed Columns3", {"FiscalBaseDate"})
in
Source

 

This is what it needed to be (instead of in Source)

in

#"Removed Columns"

 

 

Once changed it refreshed with no errors.