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

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

      • lbendlin's avatar
        lbendlin
        Super User
        6 years ago

        if you have a Pro license please raise a ticket with Microsoft. The more of us do that the sooner Microsoft will hopefully realize that this is a full blown issue and not just some individuals struggling.