Forum Discussion

jonnyA's avatar
jonnyA
Responsive Resident
2 years ago
Solved

Combining 3 datasets | Need help

How can I combine 3 datasets into 1?

  • Hi jonnyA - Before publishing it and calling from semantic models from get data  , you can combine it in desktop all three datasets if they have same column headers without change, use append transformation in query editor load the datasets in desktop and publsih it into cloud, call the datasets via power bi semantic model using get data again. this is an approach.

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

     

     

2 Replies

  • Hi jonnyA - Before publishing it and calling from semantic models from get data  , you can combine it in desktop all three datasets if they have same column headers without change, use append transformation in query editor load the datasets in desktop and publsih it into cloud, call the datasets via power bi semantic model using get data again. this is an approach.

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jonnyA 

     

    Is your problem solved, if so, please mark the corresponding reply as a solution, which will help users with the same problem to better solve their problem.

     

     

     

     

     

     


    Best Regards,

    Jayleny

     

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