'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Microsoft Fabric Connector Missing from Excel Power Query
Question details
The user is unable to select or use the Microsoft Fabric or Lakehouse connector in Excel Power Query.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to connect to data sources using Microsoft Fabric or Lakehouse via Power Query in Excel.
- Observed behavior
- The connector either does not appear at all or is visible under New Sources but remains grayed out and unavailable for selection.
Ensure you are signed into Microsoft Excel with your organizational Microsoft 365 account, as feature availability heavily depends on your specific tenant licensing and update channel.
Verify Beta Status and Update Excel Build
Since the Microsoft Fabric and Lakehouse connectors are rolled out gradually, confirming the release status and updating to the latest Excel build is the primary solution.
Connectors in beta are often visible in the Power Query user interface but remain unselectable until they are fully rolled out to your specific Microsoft 365 channel. Your organization's update policies can also delay the availability of these new connectors.
Visit the official Microsoft Power Query connector documentation (learn.microsoft.com/en-us/power-query/connectors) to verify the current rollout status of the Lakehouse and Fabric connectors.
Launch Microsoft Excel, click on the File tab in the upper-left corner, and select Account from the bottom of the left-hand navigation pane.
Under the Product Information section, click on the Update Options button and select Update Now to download and install the latest features.
Once the update is complete, restart Excel, navigate to the Data tab, click Get Data, and verify if the Microsoft Fabric connector is now selectable.
Try WPS Office for Fast and Reliable Data Processing
If you are tired of dealing with gradual feature rollouts and update channel limitations in Microsoft Office, consider switching to WPS Office. It provides a robust, lightweight, and highly compatible environment for your everyday data analysis tasks without the hassle of tiered release channels.
- 1. Download the Software: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the straightforward on-screen instructions to complete the setup.
- 3. Open Your Data Files: Launch WPS Spreadsheets and open your existing data workbooks to start analyzing your data immediately with full formatting preserved.
Frequently Asked Questions
Why is the Lakehouse connector visible but grayed out in Excel?
This happens when the connector is still in the beta phase or is part of a gradual rollout. It appears in the interface but won't be active until the feature is fully released to your specific Microsoft 365 tenant and channel.
Can I manually force the Microsoft Fabric connector to activate?
No, you cannot force a server-side feature release. The best you can do is ensure your Excel application is on the Current Channel or Beta Channel and updated to the latest build through File > Account > Update Options.
Are there alternative methods to connect to Fabric data if the connector is missing?
While the native connector rolls out, you can often work around the limitation by exporting your Lakehouse data to a supported intermediate database like SQL Server, or by utilizing an OData feed to import the data into Excel.
