Forum Discussion
Solved
Report Meta Data - name of SQL View etc
Is there a way to automatically retrieve apps/workspaces, reports, datasets and the underlying name of the table or view in SQL Server? I need a way for our documentation to know which SQL views/tab...
Hi TCavins ,
XMLA Read/Write Access , You can connect to your Power BI datasets using tools like Tabular Editor, SSMS, or even PowerShell with TOM (Tabular Object Model).
Direct Access to the Semantic Model: This lets you inspect and script out metadata, including:
Table names
Column names
DAX measures
Relationships
Partitions and source queries (including SQL views, if used)
For Ref
Solved: PowerBI Premium Licensing / XMLA / Access - Microsoft Fabric Community
Power BI Premium Per User - Microsoft Fabric | Microsoft Learn
Best Regards,
Lakshmi.
I've been on PTO and will continue looking into this this week. I've tried various options in Powershell before but I'll give this a try as well.