Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DataFormat.Error when using Table.ExpandListColumn()

Hello,   I have here a skript which generally seems to work but the step #"expandMonthList" creates a format error when loading the Data in the model:     When taking out the step #"expand...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

 

unfortunately I cant find this message anywhere. I just get the error message. No error report or anything else indicating which coulumn is causing the problem. Looking on the column quality power query its showing nowhere an error.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Since you are expanding SalesPeriod column, hence error message you should get in that column. But before that make sure column profiling based on entire data set is set. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    When I change the setting to "column profiling on entire data set" i get an unexpected error ğŸ˜“

     

     

    • Vijay_A_Verma's avatar
      Vijay_A_Verma
      Most Valuable Professional
      4 years ago

      Click on one of the errors and post the message text (not picture so that I can use Google translate). 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        there is no more message text. When I change the setting it starts computing, then it stops and only displays as on my screenshot. Maybe my computer just cant process the the profiling based on the entire data?