Himanshi0291Helper II6 years agoSolvedCombine Data Hi, Is it possible to show combine data from excel spreadsheet and SQL server in Power BI desktop/service. Thanks amitchandak6 years agoHimanshi0291 , 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
amitchandak6 years agoHimanshi0291 , 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
amitchandak6 years agoHimanshi0291 , 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
amitchandakSuper User6 years agoHimanshi0291 , 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
Related contentData Combining ProblemCombining Column DataUnderlying Error Privacy...combining of dataTables combineMedallion Architecture - best practices to combine data sources
