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 ...
Hi PowerBI_Mallow
For such size you wouldn't need to import your table but instead you will connect it using Direct query mode.
I come back to you now with an updated scenario, lets say A=Sharepoint, B=mysql and C=merged table:
- Append both tables to a new query in Power Query
- Apply the incemental refresh on table A
- Disable loading both tables A and B
- You will end up in Report view with one Table C
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
DataVitalizer ,
we are not able to use direct query due to its limiatation & we prefer import mode.
What is the difference of append the table A(sharepoint) to table(mysql) instead of append as new.
Also in your suggested method do configure incremental refresh for table C? In that case whether the query will be sent to both sharepoint source and mysql?