Combine Data

[Himanshi0291]

Hi,

Is it possible to show combine data from excel spreadsheet and SQL server in Power BI desktop/service.

Thanks

[amitchandak · Accepted solution]

@Himanshi0291 ,

Yes depend on need. If will work in import mode.

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

[ryan_mayu]

@Himanshi0291 

Could you please provide detailed info?

Hope the doc below is helpful.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

[Himanshi0291]

Hi,

Thank you for sharing the info.

What I am looking is I have a separate excel spreadsheet which has data from Accounting department and I am also pulling the data from SQL server from various tables, so is there any way I can combine the data from these two different sources into one and then further can present my data in Power BI.

Thanks