Forum Discussion
JohnSwid
9 years agoNew Member
Connecting to data source hosted on Dropbox
Hello PowerBI-Ites, Has anyone had any luck connecting to Dropbox as a data source. Couldn't find many articles on this topic. Here's one article that had a solution we couldn't get to work: h...
masplin
9 years agoImpactful Individual
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
masplin
9 years agoImpactful Individual
Found it :)
https://www.myexcelonline.com/blog/consolidate-multiple-excel-workbooks-using-power-query/