Cut the Clutter: Test Ignore Files Feature - sign up to become a beta tester here.

Forum Discussion

dn1's avatar
dn1
New member | Level 2
8 years ago

need help with Microsoft Power BI integration

Hi. I am looking for a code example on how to use Dropbox API v2 and a token to make Power BI Service connect to a folder inside Dropbox.
I have a new client that wants to witch from OneDrive but so far I found it difficult to make Dropbox API work on Power BI.
Any help?

5 Replies

  • Greg-DB's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    8 years ago

    We don't have any samples for Power BI in particular unfortunately, but we'll be happy to help with any issues you run in to. If you've starting writing code and are running in to any problems, please share the relevant code and the output you're getting and we'll take a look.

     

    If you haven't started yet, you can find all of the documentation on the developers site:

     

    https://www.dropbox.com/developers

     

    We generally recommend using one of the official SDKs if you can:

     

    https://www.dropbox.com/developers/documentation

     

    Otherwise, there are some third party libraries listed here:

     

    https://www.dropbox.com/developers/documentation/communitysdks

     

    Or, you can call the HTTPS endpoints directly:

     

    https://www.dropbox.com/developers/documentation/http/documentation

     

    There are curl examples for those that you can translate for use with your own HTTPS client.

  • dn1's avatar
    dn1
    New member | Level 2
    8 years ago

    yeah yeah... I´ve read all this links, but still couldn´t make it work.

    the only way I make it work is to read single files, as instructed by Masplin in this link.

    https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-data-source-hosted-on-Dropbox/td-p/67946/page/3

    But I need to read a full folder, and then open all files at once.

    The API v2 does not work for me at all. I tried a lot to use list_folder syntax.

    The API v1 is no longer supported and I shouldn´t use it either.

  • Greg-DB's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    8 years ago

    What specifically isn't working? If you're running in to any trouble, please share the relevant code and error/output.

     

    The Dropbox API offers an endpoint for reading file content. This requires one API call per file, so if you want to access the file content for all of the files in a folder, you'll need to loop through the desired files and call /2/files/download for each one.

  • L0h1cB3n3yz3t's avatar
    L0h1cB3n3yz3t
    New member | Level 2
    7 years ago

    Good morning,

    I'm aware that this thread is quite old but I'm facing the same problem / requirement. Have you found any solution for this?
    If yes, would you mind to share it with me?

    Thanks in advance and have a great weekend.

    Kind regards,

    Lohic Beneyzet

  • Greg-DB's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    7 years ago

    L0h1cB3n3yz3t I don't know if dn1 has any information they can share to help with this, but please feel free to open a new thread with the specifics of what's currently not working for you and we'll be happy to help with whatever we can regarding the Dropbox API.

About Dropbox API Support & Feedback

Node avatar for Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.6,039 PostsLatest Activity: 18 hours ago
415 Following

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!