Forum Discussion

Accokeekian's avatar
Accokeekian
Frequent Visitor
6 years ago

"Unexpected error" when reading sharepoint folder full of large text files using Dataflows

Hi there,   Excited for the new features of dataflows from the Nov 2019 update which allows the same "combine" files experience as in power query on desktop. Unfourtunately, when I attempt to load ...
Dataflow
Need Help
jmdh's avatar
jmdh
Icon for Advocate IV rankAdvocate IV
6 years ago

May sound dumb but does it work on PowerBI Desktop ? 

fabo's avatar
fabo
Icon for Advocate III rankAdvocate III
6 years ago

Yes, it does work on PowerBI Desktop.  No problem there.

I was trying to replicate the same over dataflows.

  • jmdh's avatar
    jmdh
    Icon for Advocate IV rankAdvocate IV
    6 years ago

    I will look further tonight : however the same code does not yield the same results in Desktop and Dataflow.
    In short: Desktop creates a Content column which contains the Binary of each excel file, while Dataflow creates a Content column which contains a Table value for each file...