New open source connector – help sought for incremental API querying

  • New open source connector – help sought for incremental API querying

    Posted by DSC Communities on May 10, 2018 at 10:46 am
    • Elian Carsenat

      Member

      May 10, 2018 at 10:46 AM

      Hi! I’m quite new to PowerBI.Ā 

      We’re building an opensource connector for measuring the gender gap accross industries, customer segmentation, human resources dashboards or any other use case. The ALPHA version works quite well. It is on GitHub:

      namsor/namsor-powerbi-connector

      This is an example of dashboard:Ā 
      http://gendergapgrader.com/2018/05/how-many-merger-acquistions-professionals-are-women/

      We’re looking for contributors and beta-testers. One of the issue is to prevent the connector to query the API when data has already been processed : we need some kind of persistent caching, or incremental refresh functionality.Ā 

      All helping hands are welcome šŸ™‚

      Best regards,

      Elian

      ——————————
      Elian Carsenat
      78000
      VERSAILLES
      652779907
      ——————————

    • Andy Parkerson

      Member

      May 14, 2018 at 1:58 PM

      Elian,

      A preliminary search returned this workaround:

      Refresh Data – Append New Data Only

      Basically copy your old data into a new query named (Old Data), get only the newest data in a query called (new data), and then merge them together.Ā 

      When you want to refresh, simply do it all again.

      Hope this helps,

      ——————————
      Andy Parkerson
      Web Developer
      ShoppersChoice.com
      Baton Rouge LA
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 11 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘New open source connector – help sought for incremental API querying’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!