Forum Discussion
Connecting to data source hosted on Dropbox
I think this is the best one for us to vote on
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6663925-dropbox
Ok so plan B. The out of the box method in power Query for querying a folder is create this big mess with sample files that is tremendusly confusing. Is there a way to just have a single qury that does the job?
For example I want to query these 2 files in a dropbox folder. The first step I see this
However if i click the arrows on binary it sets off greating the sample file.
Can I get round this with some code similar to what Imke wrote for dropbox? I assume it is a similar exercise but my M is too pooor to work it out :(
Mike
- masplin9 years agoImpactful Individual
Found it :)
https://www.myexcelonline.com/blog/consolidate-multiple-excel-workbooks-using-power-query/