|Release State||General Availability|
Power BI (Datasets)
|Authentication Types Supported||Exchange account
|Function Reference Documentation||Exchange.Contents|
Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.
Connect to OLE DB from Power Query Desktop
Power Query Desktop includes Excel, Power BI (Datasets), and Analysis Services as experiences.
To make the connection to OLE DB, follow these steps:
From Get Data, select the Other category, select OLE DB, and then select Connect. More information: Where to get data
In the OLE DB window that appears, enter your connection string. Optionally, you can provide other SQL query information in the Advanced options tab.
Avoid using credential or security properties in this connection string, as you'll enter them in the next menu.
Choose the kind of authentication you'd like to use: Default or Custom, Windows, or Database.
- Default or Custom: Enter custom or security related connection string properties, things like security strings or passwords that shouldn't be added to a query. For example 'UID=MyUserId; RefreshToken=MySecretRefreshToken; Encryption=true'
- Windows: Sign in with your current windows credentials, or provide a different Windows username and password. You can also provide any other connection string properties, if needed.
- Database: Provide your database username and password. You can also provide any other connection string properties, if needed.
In Navigator, review and select data from your database. Then select either Load to load the table, or Transform Data to open the Power Query Editor where you can filter and refine the set of data you want to use, and then load that refined set of data.
Submit and view feedback for