Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

8000 Character limit SQL Endpoint For Lakehouse Fabric

Hi! We saw this blog post.  https://blog.fabric.microsoft.com/en-us/blog/working-with-large-data-types-in-fabric-warehouse/   It mentioned expanding capabiltiy of fabric warehouse to handle varch...
data engineering
lakehouse
Anonymous's avatar
Anonymous
Not applicable
1 year ago


Hi! I just tested it out and it appears that the string still gets truncated (it's supposed to say this is a test of mass proportions done by the great richard but got cut off at "a"). Is there something i need to do to activate this update?

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    1 year ago

    Assuming you have changed the table data type and reloaded the data, could it be that the export to excel is what is truncating the data? Have you tried to query the last occurance for the last word in the string?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      I have been told by support this feature is not availble yet

  • EdouardDLMT's avatar
    EdouardDLMT
    New Member
    4 months ago

    had a similar issue, was using a dataflow in PowerApps, had an encoded image as Base64 ,too large and was truncated to 8000 caracters when i was using the SQL connector ;  Lakehouse.contents connector doesn't work in power query inside dataflows so for power apps, had to use : 

     

    let
// Lecture directe de la table Delta du Lakehouse via OneLake
Source = AzureStorage.DataLake(
"https://onelake.dfs.fabric.microsoft.com/" &
"blablabla/" & // workspace GUID
"blablabla/" & // lakehouse GUID
"Tables/dbo/NAMEOFTHETABLE/", 
[HierarchicalNavigation = true]
),

dbo_nameofthetable = DeltaLake.Table(Source),


in
dbo_nameofthetable



    this connects direclty to the delta tables bypassing the SQL endpoint