You can import your data into Microsoft Power BI through an ODBC connection.
The following procedure is written for Power BI Desktop 2.30.4246.181. Simba ODBC drivers also support earlier versions of Power BI Desktop.
Make sure that the bitness of the driver that you are using matches the bitness of Power BI Desktop. If you are using the 32-bit version of Power BI Desktop, then you need to use the 32-bit version of the driver. If you are using the 64-bit version of Power BI Desktop, then you need to use the 64-bit version of the driver. For more information about diagnosing the issue, see Architecture Mismatch Problems.
To retrieve data using Power BI:
If you are connecting to a Salesforce data store that requires a security token, then in the Credential Connection String Properties (Optional) field, type TOKEN=[YourToken], where [YourToken] is your security token.
A dialog box opens and displays the data that is returned from the data store. If you used a SQL statement to specify what data is returned, then the dialog box only displays the rows returned by the SQL statement.
The selected data is loaded into Power BI Desktop and listed in the Fields task pane. You can now use Power BI to analyze the data.
For more information about connecting to a database in Power BI Desktop, see the Power BI Help documentation that is linked from the application.
For more Power BI tutorials and how-to information, see https://powerbi.microsoft.com/en-us/documentation/powerbi-service-get-started.