Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
How To Use CData ODBC driver for Dropbox to import data in Excel with Microsoft Query
Hello, With this Power BI tool, I am trying to use the CData ODBC driver for Dropbox to import data in Microsoft Excel. I wanted to know how to use parameters with Microsoft Query so I get all th...
Follow the steps below to import Dropbox data using standard SQL:
- From the ribbon in Excel, click Power Query -> From Other Data Sources -> From ODBC.
- Enter the ODBC connection string. Below is a connection string using the default DSN created when you install the driver:
Provider=MSDASQL.1;Persist Security Info=False;DSN=CData Dropbox Source
3. Enter the SELECT statement to import data with. For example:
SELECT Id, Name FROM Files
4. Enter credentials, if required, and click Connect. The results of the query are displayed in the Query Editor Preview. You can combine queries from other data sources or refine the data with Power Query formulas. To load the query to the worksheet, click the Close and Load button.
Thanks
