Forum Discussion

Ynr0225's avatar
Ynr0225
Helper I
9 months ago
Solved

Database Tables for all datasets across all workspaces

Hi All,   Using Power BI Scanner Rest API's i extracted the metadata in Json format. Later i used that json file as a data source in Power Bi desktop and created a table visual with workspace, data...
Need Help
  • Ynr0225's avatar
    Ynr0225
    9 months ago

    Hi v-aatheeque ,

    Thanks for responding. Do you know how to get the database tables from Power Query expressions column. 

v-aatheeque's avatar
v-aatheeque
Community Support
9 months ago

Hi Ynr0225 

Thanks for clarifying your requirement. The Power BI Scanner API JSON doesn’t directly expose server, database, schema, or table names as separate fields. Those details are embedded inside the Power Query expressions column.

Ynr0225's avatar
Ynr0225
Helper I
9 months ago

Hi v-aatheeque ,

Thanks for responding. Do you know how to get the database tables from Power Query expressions column.