Forum Discussion

AnotherBIUser's avatar
AnotherBIUser
Icon for Helper I rankHelper I
3 years ago
Solved

Creating a List of Queries and Fields from Model

Hello,   I am currently trying to create a powerquery tool that will take all the queries (100+) and create a new query that has two columns: 1) The Fields in the queries 2) The name of the query...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    Hi

     

    = Table.ExpandListColumn(
        Table.RemoveRowsWithErrors(
           Table.TransformColumns(
              Record.ToTable(#shared),
              {{"Value", Table.ColumnNames}})
        ),
       "Value")

     

    Stéphane 

  • AnotherBIUser's avatar
    AnotherBIUser
    3 years ago

    Thank you so much! This is EXACTLY what I need!

slorin's avatar
slorin
Icon for Super User rankSuper User
3 years ago

Hi

 

= Table.ExpandListColumn(
    Table.RemoveRowsWithErrors(
       Table.TransformColumns(
          Record.ToTable(#shared),
          {{"Value", Table.ColumnNames}})
    ),
   "Value")

 

Stéphane 

AnotherBIUser's avatar
AnotherBIUser
Icon for Helper I rankHelper I
3 years ago

Thank you so much! This is EXACTLY what I need!