How to show all the tables in the data pane in a table visual?

[anonymous91]

I have a report which is connected to a live semantic model now i want to create a table which displays all the fact and dim tables name in my data pane, anyone has any idea how can i do that?

[Anonymous · Accepted solution]

Thanks for rajendraongole1's concern about this issue.

Hi, @anonymous91 

I am glad to help you.

If you don't have a lot of data, maybe you can choose import mode instead of live connection to use import mode, you can create a new Query in Power  Query Editor and enter the following M code (change the Query name according to your specific situation):

let
    AllQueryNames = #sections[Section1],
    CurrentQueryName = "Query1",
    PreviousQueryNames = Record.RemoveFields(AllQueryNames, {CurrentQueryName}),
    QueryNamesList = Record.FieldNames(PreviousQueryNames),
    QueryNamesTable = Table.FromList(QueryNamesList, Splitter.SplitByNothing(), {"TableNames"})
in
    QueryNamesTable

This way you can get all the table names and organize them into the same column:

Because Analysis Service model itself has many limitations, if you really can't convert to import mode, you can also create a table about table names in the data source and then get all the table names in Power BI.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @anonymous91 - While Power BI does not have a built-in function to automatically list all table names in a DAX table, the methods above (manual entry or using Tabular Editor) will allow you to display the names of your fact and dimension tables in a table visual. If you have many tables, consider using tools that can facilitate management of your model, such as Tabular Editor.

Showing DAX Expressions When Using Power BI Datasets (Live) (youtube.com)

GitHub - TabularEditor/TabularEditor: This is the code repository and issue tracker for Tabular Edit...