Forum Discussion

Millhouse's avatar
Millhouse
Regular Visitor
2 years ago
Solved

Your tips on storing Power Query tables

Hi all,   I like Power Query a lot for connecting and cleaning data that I pull from an API - using the web connector. But whenever the api calls need to happen incrementally it gets complicated. S...
Need Help
Tips and Tricks
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi Millhouse 

     

    I would honestly look at fabric because this will solve your exact issue you are having. With fabric you can use dataflow gen2 and simply say I want to append data which will keep appending the new data every time the job runs. With Fabric you can also have it pause and start so you only paying for the time when it is being used.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
2 years ago

Hi Millhouse 

 

I would honestly look at fabric because this will solve your exact issue you are having. With fabric you can use dataflow gen2 and simply say I want to append data which will keep appending the new data every time the job runs. With Fabric you can also have it pause and start so you only paying for the time when it is being used.