If you have installed 32-bit DataDirect Salesforce driver then you need to open 32-bit ODBC Administrator else open 64-bit ODBC Administrator One for 32-bit and another for 64-bit ODBC drivers. Note that there will be two ODBC Administrators in Windows. Open ODBC Administrator to configure the Salesforce driver.Stick to default options in installer and you should be done in a minute or two.
If your Excel version is 32-bit, then download the Windows 32-bit version else if your Excel version is 64-bit, then download Windows 64-bit version of DataDirect Salesforce ODBC Driver. Download Progress DataDirect Salesforce ODBC driver from our website.In the right pane, select the needed columns - id, manufacturer, and model, and the needed chart type.Īs a result, we get the following chart, we get the following chart.Īn ODBC driver takes over the task of data retrieval, allowing you to concentrate on the data analysis. Let’s say we want to create a line and stacked column chart that will display how many car models each manufacturer has in our database. Power BI doesn’t display the loaded data in a grid by default, it only creates models and identifies relationships in the data, which it caches in-memory for reports. You can preview the data by selecting the needed table.Ĭlick Load to import the data into Power BI to work on it. If I don’t specify any SQL statement, Power BI will retrieve the metadata from the Postgres database and offer you to select the table to load. With the above SQL statement executed, I’ve received only one record in the results. Type them into the respective fields and click OK. If your data source is password-protected, Power BI will prompt you for the username and password. Optionally, you can enter a SQL statement to execute against the ODBC driver in the Advanced options - for example, if you want to filter or sort the data in the table rather than to load the entire dataset. In the From ODBC dialog box, expand the Data Source Name (DSN) drop-down list and select the DSN that you’ve configured for your data source. In Power BI Desktop, click Get Data, then select Other > ODBC category. For the purpose of this post, I’ve created a ‘cars’ table in my Postgres database and populated it with mock data.
I’ll show you how to load data from the PostgreSQL database into Power BI with the help of the corresponding ODBC driver, but the steps covered here are almost the same for other databases, feel free to replicate them for other data sources. The driver serves as an intermediary between the data source and the application you want to pull the data into, and is really easy to install and configure. By cloud applications, I mean the likes of MailChimp, Salesforce, BigCommerce, etc. For users who are not familiar with the ODBC technology, I’ll briefly explain what it is: ODBC is a standard application programming interface that allows applications such as Power BI, Microsoft Excel, and hundreds of other apps that support ODBC connectivity, to access data in various databases and cloud applications. There are plenty of ODBC drivers, both open source and commercial, for almost any data source.