Forum Discussion

James1965's avatar
James1965
Helper I
9 years ago
Solved

OneDrive does not update data

I try to use OneDrive together with dashboard, but updaqting of the data doeas not work. Could you figur out what is the problem?   regrads  
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi James1965,

     

    Based on my test, We can connect to multiple .CSV files exist in OneDrive for Business in Desktop, we need to creat each web query to connect to separate .CSV file. After publish the report to service, we can go to the dataset settings enter credential for data source and set schedule refresh.

     

     

    Best Regards,

    Qiuyun Yu

DataChant's avatar
DataChant
Most Valuable Professional
9 years ago

Hi James1965,

 

Do you use OneDrive or OneDrive for Business? Only the latter supports auto-refresh.

 

In addition, assuming you use Excel files, please confirm that your Excel files on OneDrive for Business are explicitly refreshed by you. Power BI can only pull the data from an already refreshed workbook, it will not refresh the Excel files themselves.

 

  • Vishnu's avatar
    Vishnu
    Regular Visitor
    9 years ago

    Hi, Could you tell me whether we need to set up a scheduled refresh for Power BI online to refresh data from One Drive for Business or does it happen automatically?

  • James1965's avatar
    James1965
    Helper I
    9 years ago

    Hi,

    Thank you. I use OneDrive for Business, but data are many csv-files in a folder. More csv-files are moved in over times.

    • DataChant's avatar
      DataChant
      Most Valuable Professional
      9 years ago

      Can you check which refresh error you get, when you select the dataset in PowerBI.com --> Datasets?

      Do you use the import from folder in your query to append the CSV files into a single table?

       

      I think that this functionality isn't supported by the service - only a direct download of CSV/Excel files from OneDrive for Business.

      • James1965's avatar
        James1965
        Helper I
        9 years ago

        Hi,

         

        If I "Update the dataset now", I get the wrong massage,

        You data gateway (Power BI – personal) is offline or could not reached.

         

        The fact is that I have removed personal gatwway and installed a interprise gateway. To my knowlege however, it would not use gateway to connect dataset on OneDrive.

         

        Regarding download of CSV/Excel files from OneDrive, I don't know how to direct download CSV-files. My query is,

        Imported CSV = Csv.Document(#"Combined Binaries",[Delimiter=",", Columns=6, Encoding=1252,

         

        I summarise the questions,

        1. Does Power BI support import of multiple CSV-files (in a folder) on OneDrivefor Business, with automatical data refresh?
        2. If the answer to above question is yes, then in which way the files should be imported? Or what is the problem for me?
        3. If the answer to above question is no, then which types of file are supported? A singel CSV-file? Access database file? or others on OneDrivefor Business?

        Thanks!