Forum Discussion
Append query for two datasource
We have three years of business data now, recent 2 years of data will always in the mysql database and other years will be stored in sharepoint (currently 1 year data) on the next year in sharepoint ...
Here is a quick answer on the going, Power BI supports your need, you can import each table aside, but since you want to apply incremental refresh I guess it would be better combining them using DAX (UNION function) rather than using Power Query.
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge