Forum Discussion
Fabric Warehouse Connection to Excel
Hello Suyog1
To connect client tools with Fabric warehouse, both item level access and a workspace role (either viewer or explicit share) are needed.
You have already given item level permissions, including Read and ReadData with the necessary GRANT. I suggest the next step is to share the Fabric warehouse item with the individual or group.
For more details, refer to this Microsoft documentation:Share Your Warehouse and Manage Permissions - Microsoft Fabric | Microsoft Learn
Super UserHello Suyog1
To connect client tools with Fabric warehouse, both item level access and a workspace role (either viewer or explicit share) are needed.
You have already given item level permissions, including Read and ReadData with the necessary GRANT. I suggest the next step is to share the Fabric warehouse item with the individual or group.
For more details, refer to this Microsoft documentation:
Share Your Warehouse and Manage Permissions - Microsoft Fabric | Microsoft Learn
Thank you for the information and input.
But to connect fabric warehouse via excel, we need to provide workspace level access it seems.
But Using Sql Server Connection in Excel, I was able to conenct with the approach you shared.
Thank you.
v-dineshyaCommunity Support
Hi Suyog1 ,
Thank you for reaching out to the Microsoft Community Forum. could you please try the proposed solution shared by deborshi_nag ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
