Forum Discussion
Himanshi0291
6 years agoHelper II
Combine Data
Hi, Is it possible to show combine data from excel spreadsheet and SQL server in Power BI desktop/service. Thanks
- 6 years ago
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
6 years agoSuper User
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
6 years agoHelper II
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