Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Elian Carsenat]

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]

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
——————————
——————————————-