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 

 

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

  • Arjun_SP's avatar
    Arjun_SP
    Frequent Visitor
    6 years ago

    Anonymous  I had a similar issue, the easiest thing to do is to load all the tables to SQL Server and then combine them and adding a simple query to get the table names appended and then feed to Power BI.