Combine same dataset from different source

[aidelshahaudit]

I have problem and average user of Power Bi.. is there a way to combine 2 dataset or more from diffrent data source into one using power bi desktop so... the data dan be publish into 1 data set

[nishalit]

Absolutely - You can bring data from multiple data sources into a single Power BI Desktop report. Tables from multiple data sources can be loaded into the Data Model and related via "Data Model Relationships", or combined into a single table (via JOIN or UNION operations, which in Power BI Desktop are named Merge and Append respectively) from within the Query Editor. These links will give you more information: Relationships: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-2-manage-data-relationships/ Combining multiple queries: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-and-combine-data/