Importing multiple CSV files from OneDrive or Azure

[TePe]

Hi, I would like to have weekly CSV files and Power BI should pick up what it finds at a spot (all files will have the same structure). This spot can be OneDrive (my colleagues preparing the data don't like that), Azure (which service would be feasible?) or any other place where I can put the files within the cloud.

Any ideas?

[Greg_Deckler]

Use Power BI Desktop and use the get data from Files | Folder option? When I do that, my One Drive shows up as a potential source.

[TePe]

Ups, missed that one... Hope that this will work with automatic data refresh as well...

[Greg_Deckler]

Yeah, good luck, have been struggling with that myself. It is purportedly supported, but I've run into a lot of bugs with various different "supported" data sources.

https://support.powerbi.com/knowledgebase/articles/474669-refresh-data-in-power-bi

That being said, they did seem to fix the SharePoint Online OAuth2 issues.