OneDrive does not update data

[James1965]

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

[SandraSidorova]

I use onedrive personal (.xlsm file).  

My data is changed by a macro (Locally). Sent to the cloud onedrive person each hour

[DataChant]

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]

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]

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]

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]

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 · Accepted solution]

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]

---

@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?

[DataChant]

Your scenario should be supported. This article can help you: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-onedrive-business-links/

You can also follow my answer here to see M code that is supported:
http://community.powerbi.com/t5/Desktop/Import-Excel-workbook-datamodel-from-OneDrive/m-p/92716#M391...