Forum Discussion
INFO.STORAGETABLECOLUMNS() Function access using Published Semantic Model - Need help
Hi Everyone, I hope you're all doing well. I am currently trying to access the function `info.storagetablecolumns()` on a published dataset using Power BI Desktop. Although I hold an admin role a...
Step 1: Confirm the workspace is Premium (or PPU)
Without Premium / PPU / Fabric, DISCOVER DMVs are not supported.
Step 2: Enable Read/Write XMLA endpoints
In the workspace settings:
Set "XMLA Endpoint" = Read/Write"
(Read-only will not allow DISCOVER DMVs.)Step 3: Add yourself as Dataset Admin
Even Workspace Admin is not enough for some DMV operations.
Go to the dataset's permissions and add yourself as Admin.
Step 4: Reconnect to the model via XMLA
Use Power BI Desktop, Tabular Editor, or SSMS, connecting with the dataset’s XMLA endpoint.
Then execute:
EVALUATE INFO.STORAGETABLECOLUMNS()It will now work.
Note: AI helped me to format this response.