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?