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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Accokeekian ,

Any advanced operations you add in your query tables? If these operations work on the desktop but not able to execute on dataflow side, it means some of the custom steps are invalid on the dataflow side.

You can try to assign these queries to computed entities to confirm if they work in high permissions. (computed entity allow more operations)

Using computed entities on Power BI Premium 

BTW, if you transform your '.log' file to '.txt', did these queries work on dataflow side? (for security reasons, some of the functions only work with common file types when you work on service side)
Regards,

Xiaoxin Sheng

  • Accokeekian's avatar
    Accokeekian
    Frequent Visitor
    6 years ago

    Thanks for your response. At this point in testing I am not using any complex operations built into my queries, I am just using the basic functionality of combining a series of files within a sharepoint folder using the UI.

     

    I had read that filetypes could be an issue and have experiemted with renaming the files from .log to .txt, .csv and other more common types with no sucess.

     

    FYI - This is all taking place in a premium workspace

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Accokeekian ,

      I can't find out the reason of your scenario from your description. Maybe you can open a support ticket to get further support from power bi team.

      submit a support ticket

      Regards,

      Xiaoxin Sheng