Forum Discussion

Ynr0225's avatar
Ynr0225
Icon for Helper I rankHelper I
11 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
    11 months ago

    Hi v-aatheeque ,

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

Ynr0225's avatar
Ynr0225
Icon for Helper I rankHelper I
11 months ago

Hello lbendlin ,

Thanks for responding higher officials wants it in csv file. We don't have any database or warehouse. Actually i want database tables and schema used in Power BI.
If anyone knows how to get the database tables and schema from Power Query Expressions. please let me know.

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
11 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
    Icon for Helper I rankHelper I
    11 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
      Icon for Super User rankSuper User
      11 months ago

      Tables are not expressions, they are partitions.

      • v-aatheeque's avatar
        v-aatheeque
        Icon for Community Support rankCommunity Support
        11 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.