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,

 

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