Forum Discussion

Miguel_Rojo's avatar
Miguel_Rojo
Icon for Helper II rankHelper II
1 year ago
Solved

Dataflow - SharePoint Connection Problem

Hi Community,   I've been expierience a anomal behivor when a SharePoint folder connection is executed in my Dataflow. Here the scenario:   Dataflow connects to a Sharepoint folder using the .C...
Need Help
Miguel_Rojo's avatar
Miguel_Rojo
Icon for Helper II rankHelper II
1 year ago

Hi Akash_Varuna, v-prasare 

 

Thanks for the approach solutions; I really appreciate them.

I treid to apply your approach:

  1. Desable the "Column Types" detection in the "Project" section of the Dataflow
  2. Select the option of "Never detect column types fro unstructored process" on the "Global" section 

 

However, when I click "Save and Close", the Dataflow continues adding the extra step that converts my column with the SharePoint folders to "Text Data Type", and when I look the "Data Load" option, I see that Power Query doesn't repesct my past unselection and selects againg the option of "Detect Column Types":

 

Have you expierenced a similar issue?

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

    Hi Miguel_Rojo , Could you try to remove it manually and then saving the Dataflow and look for any Tyoe Changes in Advanced editor and if there is any delete it and save the dataflow 

    • Miguel_Rojo's avatar
      Miguel_Rojo
      Icon for Helper II rankHelper II
      1 year ago

      Hi Akash_Varuna,

       

      That's the couriose thing:

      1. I delete the "undesired transfomrations steps"
      2. I confirm in the "Advance Query Editor" that they have been removed
      3. I confrm that my project has disable the "Automatically Identified Column Types..."
      4. I proceed to "Close and Save" and "Refresh" my dataflow 
      5. During the refresh process, autoamtically it keeps "Converting my table folder into a Text data type" (which breaks everything)

       

      Is there a way to indicate that "This column representa SharePoint folder"?, so that Power Query doesn't insist in convert it to "Text"?