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. 

  • lbendlin's avatar
    lbendlin
    Super User
    9 months ago

    Tables are not expressions, they are partitions.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      8 months ago

      Hi Ynr0225 

      Just checking in to see if the clarification helped.
      As mentioned earlier by lbendlin , tables themselves won’t appear directly in the Power Query expressions column since those expressions represent query logic, whereas tables are stored as partitions within the dataset.