Forum Discussion

RomanTesolkin's avatar
RomanTesolkin
Frequent Visitor
1 month ago

Power BI & Mirrored Databricks Catalog — Table Access Forbidden errors despite Unity Catalog access

I'm setting up a Mirrored Azure Databricks Catalog in Premium Capacity and getting persistent sync errors on tables, even after granting Unity Catalog permissions and configuring OneLake security roles.

I can see the catalog and schema structure in the Fabric Explorer, and I can query the same tables directly in Databricks with no issue. But tables fail to sync into the mirrored item, and I get 'Couldn't access data' when trying to browse their content in Power BI service. Also i can query these tables in to Power BI iver standard Azure Databricks connector over get data, no access etc issues.

 

Error details:

  • Error code: TableAccessForbidden
  • Message: "Unable to sync the table due to insufficient permissions."

  • What I've already checked/done:

    1. Confirmed Unity Catalog is enabled on the source catalog.
    2. Granted USE CATALOG, USE SCHEMA, SELECT, and EXTERNAL USE SCHEMA at catalog/schema level in Databricks for the relevant groups.
    3. Confirmed External Data Access is enabled on the metastore.
    4. Configured OneLake security (added a reader role with Read grant on the affected schema) — this did not resolve the sync error.
    5. Refreshed/retried the sync — error persists on specific tables only.

      Is there anything missing on DBX side or Power BI? Any guidance appreciated — happy to share more sync logs if useful
Need Help

11 Replies

  • v-achippa's avatar
    v-achippa
    Community Support
    1 month ago

    Hi RomanTesolkin,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Since only specific tables are failing while others sync successfully, looks like this is not general fabric or unity catalog issue.

    • Please check whether the affected tables are external tables pointing to a different ADLS location and also verify that the underlying storage permissions and network access are available to fabric.
    • Also compare the failing tables with a working one so that we can confirm that the affected tables are of a supported type for mirroring. 

    If these checks are valid and the issue persists, I recommend you to raise a Microsoft support ticket with the logs for further investigation.

    Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

     

    Thanks and regards,

    Anjan Kumar Chippa

    • RomanTesolkin's avatar
      RomanTesolkin
      Frequent Visitor
      1 month ago

      Hi Anjan,

       

      thanks for the inputs.

       

      all tables set this way are failing, i can query them in databricks without issues. Also i can query them in Power BI over standard Azure Databricks connector, however over mirroring, i get  insufficient permissions issue.

      • v-achippa's avatar
        v-achippa
        Community Support
        1 month ago

        Hi RomanTesolkin,

         

        Since only specific tables fail, looks like those tables most likely have row filters or column masks applied in unity catalog. Databricks blocks those tables with row-level security or column masks from being mirrored to external systems like fabric, so you get TableAccessForbidden even though the required permissions are correct.

        Remove the row filter or column mask from those and then retry the sync.

         

        Thanks and regards,

        Anjan Kumar Chippa