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"?

     

     

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

        Hi v-prasare,

        Thanks for your attention on this topic.

         

        The issue was not solved.

        The Dataflow keeps executing those undesired transformation steps (converting my sharepoint folders tables in "Text" data type) no matter how many times I disable the "Automatically Identified Column Types..."

         

        The workaround that I'm using is:

        • Instead of having one query that makes reference to "different SharePoint folders" and then referencing that "Parent query" by other "Child queries"
        • I create one direct query to each "Sharepoint folder" and complete the rest of transfomations in that query (without making references)

         

        Thanks, 

        Miguel