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.