Forum Discussion

pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
1 year ago
Solved

Unable to refresh dataset with Column content exceeding 315 characters

Hi All,   I am facing one issue while refreshing a dataset with column length more tan 315 characters. It does not throw proper error, Just refresh stops with invalid credentials. And if i decrea...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

what is "column length" ? Size of the column name, or size of the column content?

 

There are various limitations that sometimes even combine , for example "10000 rows or 1000000  elements, whichever comes first").

 

What's the source of your semantic model?

pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
1 year ago

Hi lbendlin ,

It's the content of a column that exceeds 300+ chars and causes refresh issue 

Thanks,

Pallavi

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    Text in columns can be up to 32K characters long. There must be something else going on.  What's the source of your semantic model?

    • pallavi_r's avatar
      pallavi_r
      Icon for Super User rankSuper User
      1 year ago

      Hi lbendlin 

      The source is SharePoint list to capture the metadata where I have further expanded the attributes in the power query.

      Thanks,

      Pallavi

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        1 year ago

        Then the limitation is likely coming from the source. Single line of text or multi line?