Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

xupzhou
‎03-24-2026 02:30 PM

SharePoint Site Picker for easily connecting SharePoint data in Microsoft Fabric (Preview)

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings. 

The SharePoint Site Picker simplifies the process by replacing the manual URL entry with a browsable and searchable dropdown menu. By enabling site discovery directly within Fabric, it helps prevent URL format errors, reduces connection issues, and allows you to concentrate on building your data integration instead of searching through SharePoint.

This_is_gif_for_showing_all_the_SharePoint_site_picker_functionsThis_is_gif_for_showing_all_the_SharePoint_site_picker_functions

Figure: SharePoint site picker functions overview.

With SharePoint Site Picker you can use the same browsable dropdown across the following Fabric experiences and connectors:

  • Dataflow Gen2 — SharePoint Folder, SharePoint Online List, and SharePoint List sources, plus SharePoint destination.
  • Pipelines — SharePoint Online List in source.
  • Copy job — SharePoint Online List in source.
  • Lakehouse shortcut — SharePoint Folder.

Simplified SharePoint site selection

When you connect to a SharePoint source or destination, the Site URL field now includes a dropdown with two categories: Recent sites and Favorite sites. Select the dropdown, choose a site, and the connector populates the correct site URL automatically.

This_picture_shows_the_SharePoint_site_picker_dropdown_experienceThis_picture_shows_the_SharePoint_site_picker_dropdown_experience

Figure: SharePoint Site Picker drop down.

Quick search capability

When your target site isn’t in your Recent or Favorite list, type a keyword in the dropdown search box. The Site Picker searches across all SharePoint sites in your tenant and returns matching results in real time. Select a result, and the correct URL is entered for you.

This_picture_shows_SharePoint_site_picker_searched_resultsThis_picture_shows_SharePoint_site_picker_searched_results

Figure: SharePoint Site Picker search results.

Next steps

You can start using the SharePoint Site Picker the next time you connect to SharePoint data in Microsoft Fabric.

Have feedback on the SharePoint Site Picker? Share your thoughts in the Fabric Data Factory IDEAS community.

0