Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
New to Power BI so this may be answered elsewhere.
I am using Power BI to report out of a new ERP system (ODBC) from 01/01/17.
I have historic sales data from old ERP system that I can import as a table.
What is the best way to merge these two data sources and still be able to refresh via ODBC..?
Depends, I would look into an Append query or a Merge query, sounds like Append would be the way to go but you would have to make everything line up in the data. Failing that, you would have to structure your measures in such a way that you accounted for both tables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |