INFO.STORAGETABLECOLUMNS() Function access using Published Semantic Model - Need help

Thankyou, Thomaslleblanc, for your response.

Hi satishorre20,

Thank you for confirming that the Build permission has already been granted. Since the error “The user does not have permission to call the Discover method” persists, the issue may not be related to dataset level permissions.

Based on my understanding, INFO.STORAGETABLECOLUMNS() depends on a DISCOVER metadata call through the XMLA endpoint. This call is restricted unless your tenant and workspace explicitly permit XMLA metadata discovery. That is why the function works in Power BI Desktop (which has full local engine access) but fails on the published semantic model.

Please verify the following steps, as they may help resolve the issue:

1. In the Admin Portal, under Tenant settings, ensure that “Allow XMLA Endpoints” and “Analyze in Excel” are enabled for your user or group.
2. DISCOVER operations are permitted only in Premium or Fabric workspaces. Go to the Workspace settings and confirm that the Capacity is set to Premium or Fabric.
3. After updating Build or XMLA permissions, refresh the desktop token by choosing Power BI Desktop → File → Options → Data source settings → Sign out → Sign in again.
4. Try connecting to the workspace XMLA endpoint using the same user credentials via SSMS: powerbi://api.powerbi.com/v1.0/myorg/<workspaceName>. If SSMS also fails with a DISCOVER error, XMLA metadata access is still blocked at the tenant or capacity level.

For further reference, please refer the links below:
Semantic model connectivity and management with the XMLA endpoint in Power BI - Microsoft Fabric | Microsoft Learn
What is Power BI Premium? - Microsoft Fabric | Microsoft Learn
Semantic model connectivity and management with the XMLA endpoint in Power BI - Microsoft Fabric | Microsoft Learn

We hope the information helps to resolve the issue. If you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.