Forum Discussion

Miguel_Rojo's avatar
Miguel_Rojo
Helper 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
v-prasare's avatar
v-prasare
Community Support
1 year ago

Hi Miguel_Rojo,

Thanks for reaching out MS Fabric community support.

 

Akash_Varuna, thanks for your promt response.

 

When you save and refresh the Dataflow, Power BI might be trying to automatically detect column types, causing it to incorrectly convert the Content column to text or if the schema of the SharePoint folder changes (e.g., new files or folders are added), Power BI might reinterpret the column types.

Did you tried below step:

go to Dataflow settings in Power BI Service: Disable "Auto-detect column types and headers for unstructured sources."  This prevents Power BI from forcing incorrect data types.

 

 

 

 

Thanks,

Prashanth Are