Forum Discussion
Connecting to data source hosted on Dropbox
Really? That is a pain!
Actually, I don't have a gateway in place on my local machine, so that could explain why it still works for me.
JAkerblom : How about you: Do you also don't have a gateway installed?
I think this is the best one for us to vote on
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6663925-dropbox
I already voted. Thanks for the link.
So far, the only way to make PBI Service work is loading single files using the code from user Masplin.
3rd comment on 3rd page of this same topic.
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