cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Sharing lists tables but says "access to resource is forbidden" when reading table contents

Meagan
New Contributor III

I am using Power BI Desktop to connect to Unity Catalog using Delta Sharing. When I connect, I enter my endpoint, enter my bearer token, browse the catalog and can see my tables. But when I try to preview or load a table, I get the error "access to resource is forbidden". 

I know the endpoint and bearer token are correct, since I can list the tables that I should be able to see. It's like there is a storage permissions issue, but I'm not sure what that would be. I'd appreciate any advice on things to try. 

Meagan_0-1690388250151.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Meagan
New Contributor III

It turned out we had to allow my IP address on the storage account used by Unity Catalog. I guess i wasn't expecting to need that for Delta Sharing, but that indeed did fix the problem. 

View solution in original post

1 REPLY 1

Meagan
New Contributor III

It turned out we had to allow my IP address on the storage account used by Unity Catalog. I guess i wasn't expecting to need that for Delta Sharing, but that indeed did fix the problem. 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group