Publish Power Query Source tables to Report View

[satishorre20]

Greetings,

         I need a requirement to present power query source tables and columns information in Power BI Report.  Is there way to publish them in Report view using any DAX function like info.view.columns()/tables()/measures() from Power Query source tables and columns.

 We can see the logic in TMDL View when we drag query object from Data Pane and drop in TMDL View in Power BI Desktop, but I wanted to show these columns and source tables as data dictionary.

I have created data dictionary report using info.view.columns() , info.view.tables(), info.view.measures() and info.view.relationships() objects and, I wanted to show actual source objects and their columns in this report and /or another report.

Please share your thoughts when you get a chance.

Thank you in advance for your help and your time.

[v-venuppu]

Hi @satishorre20 ,

As we haven’t received any further updates and there are no outstanding queries at the moment, we’ll proceed to close this thread for now. If you have any additional questions in the future, please don’t hesitate to start a new thread we’re always here to help.

Thank you.

[v-venuppu]

Hi @satishorre20 ,

Please let us know once you have reviewed the information.

Thank you.

[v-venuppu]

Hi @satishorre20 ,

To publish Power Query source and transformation metadata as a data dictionary in Power BI, you can follow a semi-automated approach using pbi-tools. First, save your Power BI file as a .pbip project (you can enable this from the Preview features in Power BI Desktop), or export it as a .pbit template. Then, install and run pbi-tools (Welcome to pbi-tools | pbi-tools an open-source command-line utility) to extract the Power Query M code from your project. This will give you all your queries in individual .m files inside a folder. From each file, you can manually extract useful metadata such as the query name, source type (like SQL Server or Excel), the original source object (like dbo.FactSales), and each transformation step (such as filtering, renaming, or merging).

Once you collect this information, organize it into a structured table (e.g., using Excel or CSV) with columns like: Query Name, Source Type, Source Table, Step Name, and Transformation Description. Load this table into Power BI as a regular data table. You can then build a data dictionary report that displays the lineage and applied steps of each query in an easy-to-read format using table visuals, slicers, and filters. Optionally, you can combine this with INFO.VIEW.COLUMNS() or INFO.VIEW.TABLES() to connect your Power Query metadata with the final model columns for a full end-to-end documentation view.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

Thank you.

[satishorre20]

Hi @v-venuppu ,  Thank you for sharing the details on this. Let me review the details and will update you when I have any updates on this.

Thank you again for your time and your help.

Satish

[satishorre20]

Hi @Akash_Varuna / @v-venuppu ,  Thank you for the quick response on this.  I need to check how we can extract from source object to Query with multiple transformation Applied steps in Power Query and publish metadata as a query in Power BI Model View. So we can publish the logic in Data Dictionary.  I am still looking into it.

Thank you again for  your suggestions. 

Satish

[v-venuppu]

Hi @satishorre20 ,

I hope this information is helpful.If this answers your question, please accept it as a solution,so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @satishorre20 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu]

Hi @satishorre20 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Akash_Varuna for the prompt response.

I want to check if you had the opportunity to review the information provided and resolve the issue.If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[Akash_Varuna]

Hi @satishorre20 For this extract metadata using custom Power Query queries or SQL to list table and column names. Load this metadata into Power BI as a table and visualize it using a matrix or table visual. Use tools like Tabular Editor to export schema details if needed. Unfortunately, direct DAX functions like info.view.columns() aren’t available, so manual extraction is required.