Forum Discussion

TCavins's avatar
TCavins
Helper V
1 year ago
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...
Need Help
v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

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

Announcing the general availability of read/write XMLA endpoints in Power BI Premium | Microsoft Power BI Blog | Microsoft Power BI

 

Best Regards,

Lakshmi.

 

TCavins's avatar
TCavins
Helper V
1 year ago

Thank you.  I do not think this will be cost affective as I'm looking at trying this out for all of our existing apps and we'd have to make everyone who accesses them a premium user as well.

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    1 year ago

    Hi TCavins Thanks for confirming.

     

    Best Regards,

    Lakshmi.