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. 

lbendlin's avatar
lbendlin
Super User
9 months ago

Load the JSON into a database or data warehouse that can handle them natively.  Then connect your Power BI to that data source. That way you can eliminate the "Export to CSV" step.

Ynr0225's avatar
Ynr0225
Helper I
9 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
    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.