Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error with csv files

Bonjour, je reçois 50 fichiers csv chaque jour qui sont stockés dans un sharepoint. Chaque fichier comporte 2 colonnes et 146 lignes.  J'ai créé un flux de données pour lire les fichiers csv et e...
Need Help
lbendlin's avatar
lbendlin
Super User
6 years ago

These are rather small files. What was your reasoning for doing this with a dataflow?

 

Are you aware that unless you you use direct query you need to refresh both your dataflow and dataset in order for the data to make it to the app/report?

 

I would recommend using a dataset instead, with the standard sharepoint folder processing .

 

Have a look at this similar thread

https://community.powerbi.com/t5/Service/Loading-a-new-file-on-SPO-without-re-publish/m-p/1251368#M103707

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello,

    Thank for your answer.
    I tried your solution.

    Get CSV File function generates this error
    Expression.Error: File import does not match any export. Did you forget a module reference?

     

    And in the query, the CSV column contains ERROR

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Sorry, it's okay.

      I had forgotten (File) => in the function.

       

      I continue

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have used thes lbendlin's solution.
    4 times the update correctly ended correctly but the 5th I get the same error

     

    Thank's for your help

    • lbendlin's avatar
      lbendlin
      Super User
      6 years ago

      What's the error message?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Also the same

         

        DataSource.Error: SharePoint: La requête a échoué:
        https: // / / General / 09 - Fichiers Conso SFTP / ELEC - R + 2 Z2 w4_4_2020 1_05 AM_csv
        / _api / contextinfo
        ID de la requête: 98a56514-56e3-4f91-a73f-3b1ec553c670
        ID d'activité : a955cf7a-e0ea-4f95-afc5-3d9018174ee9