Forum Discussion

James1965's avatar
James1965
Icon for Helper I rankHelper 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

James1965's avatar
James1965
Icon for Helper I rankHelper 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!

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
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

  • otravers's avatar
    otravers
    Icon for Community Champion rankCommunity Champion
    9 years ago
    v-qiuyu-msft wrote:

     

    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.

     


    v-qiuyu-msft, just to be clear, are you saying it is not possible to have a OneDrive for Business "watch folder" that would be the source of a Power BI file, so that new CSVs uploaded to that folder would be automatically picked up by the file's preset query?