Forum Discussion

PowerBI_Mallow's avatar
PowerBI_Mallow
Frequent Visitor
2 years ago

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 ...
Need Help
PowerBI_Mallow's avatar
PowerBI_Mallow
Frequent Visitor
2 years ago

DataVitalizer , Thanks for the inputs,
As my table size is huge 60GB, is it advisable to use dax function here. Also, i would like to know incremental refresh won't work for append queries in power query in my case?

  • DataVitalizer's avatar
    DataVitalizer
    Super User
    2 years ago

    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:

    1. Append both tables to a new query in Power Query
    2. Apply the incemental refresh on table A 
    3. Disable loading both tables A and B
    4. 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

    • PowerBI_Mallow's avatar
      PowerBI_Mallow
      Frequent Visitor
      2 years ago

      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?