Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic name extraction.

Hello All,  I have around 43 tables in power bi desktop which I want to append into one table. But I also want to add a column that has the Table names in it corresponding to each row. I did see ma...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Profiling is easy you can reference this table and add extra column like below.

     

    The transformation could be done in a similar way however I would advise creating a function for transformations.

     

    Another option would be doing all the transformation in dataflows.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

Cool, I think there might be a better way.

In Query Editor.

  1. Create a Blank Query and Past the below, into the Advanced Editor 
    let
    Source = PowerBI.Dataflows([])
in
    Source
    this will create a table with all workspaces that are available to you.
  2. Find the workspaceName and click on [Data] Column > "Folder", this will show you a list of all the dataflows within that workspace.
  3. Find your workspace and click on [Data] Column > "Database", this will the list of all the tables within this dataflow.
  4. Now, select entity ( your table names ) column and Data Column and Right Click > Remove Other Columns
  5. you should have a table like below.
     
    All you need to do now is expanding your tables by clicking on the highlighted arrows and selecting the columns to expand.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski


 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Mariusz  actually after we get tables from the dataflow we are doing a data profiling transformations on all of them so that we can get information about their columns and than appending them.  How will I do this tranformations then.

     

    Table.Profile(Table 1)

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi Anonymous 

       

      Profiling is easy you can reference this table and add extra column like below.

       

      The transformation could be done in a similar way however I would advise creating a function for transformations.

       

      Another option would be doing all the transformation in dataflows.

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      Mariusz Repczynski

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Mariusz  Yes. I did try that. Still the expand step is taking like forever. I dont know whats wrong with it.

        ThankYou very much though. I appreciate your help:smileyhappy:.

        Regards,

        Chahat