Power BI data source tables and their queries

Hi Ynr225 ,

Thanks for raising this question in Microsoft Fabric Community.

As already suggested by maruthisp ,Power BI Helper is a great starting point to extract detailed metadata from your .pbix files, including data sources, tables, and queries. You can use it to identify which Netezza or IBM DB2 tables are used in Power BI Desktop before the report is published.

In addition, here are a few other approaches you can consider:

1. In Power BI Desktop:
Go to File > Options and settings > Data source settings to view the database connections (e.g., Netezza or DB2) used in the report.

You can also inspect Power Query Editor to view the actual table references and SQL queries.

2. If the report is published in Power BI Service:

Use Power BI Lineage View to trace the dataset and data source.

Navigate to Settings > Dataset > Data source credentials to identify DB connection details.

3. Using PowerShell (Get-PowerBIDatasource)
If you have access to Power BI PowerShell modules:

Get-PowerBIDatasource -DatasetId <DatasetID> -WorkspaceId <WorkspaceID>
This will help you find which datasets are connected to Netezza or DB2 servers across your workspace.

Get-PowerBIDatasource (MicrosoftPowerBIMgmt.Data) | Microsoft Learn

How to use: Power BI Cmdlets reference | Microsoft Learn

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you.