Forum Discussion

Helper II

6 years ago

Solved

Combine Data

Hi,

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

Thanks

amitchandak
6 years ago
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

3 Replies

ryan_mayu
Super User
6 years ago
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
  Helper II
  6 years ago
  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
amitchandak
Super User
6 years ago
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