Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Use the New module to find a connector for a database, file, or service. Start here when you know the kind of source you want to use.
Search for a connector by name across categories, or select a category to browse its connectors. Select a connector to open its connection settings.
The available connectors and required connection fields depend on the host and source. Selecting a connector starts a connection workflow; it doesn't immediately load data to a destination.
Find and connect to your source
After you choose a connector in New, configure its Power Query connection:
- Enter the source details, such as a server address or file URL. Choose an existing connection or provide the credentials needed to create one. Select a gateway if the source requires it.
- Continue to the source's preview or navigator, select the data you need, and open it in the Power Query editor.
The required fields and navigation steps depend on the connector. Use the connector documentation for exact instructions. For example, the OData connector takes a service URL, while the SQL Server connector takes a server name and optional database.
After you select the data, you can transform it in the Power Query editor and configure the load behavior supported by your product.
Choose another starting point when appropriate
If the data is an existing Fabric item, use the OneLake catalog to find it by its catalog context instead of entering connection details. To return to an item you used before, use Recents & My Queries.
If you can't find a connector, check whether your product supports it in Connectors in Power Query. Connector availability differs across Power Query products.