Forum Discussion

Christoph_62's avatar
Christoph_62
New Member
8 years ago

Intergation CRM insightly with Power BI

Dear Support Team,   I have connected my CRM (insightly) with Power BI some time ago.    Unfortunately, the information provided by one tile (Bing/ my contacts worldwide) is in a complete mess. S...
Need Help
Christoph_62's avatar
Christoph_62
New Member
8 years ago

Hello,

 

I am using PowerBI linked to my CRM from Insighly. One report in PowerBI shows all my contacts on a world map. Unfortunately, the data are incorrected, e.g. Jerusalem can be found on this map in Latin America and Switzerland is now located around New York etc. . To help you finding a solution for this problem, I can provide the following technical data which I copied from PowerBI:

 

QUOTE

Wenn Probleme mit der Kachel auftreten, besuchen Sie die Supportseite, oder wenden Sie sich an den Support. Stellen Sie dem Support diese Details bereit.

Kachel-ID49038

Abfragehash-1938205519176273600

Benutzerobjekt-ID65700929-4c0e-4935-af10-3e3de4e961e0

Dashboard-ID34240

Paket-ID77490

Zeit der letzten Aktualisierung des Pakets‎08‎.‎07‎.‎2016‎ ‎18‎:‎15‎:‎46

Letzter Aktualisierungsstatus des Pakets0

Zeit der nächsten Aktualisierung des Pakets‎07‎.‎11‎.‎2017‎ ‎09‎:‎14‎:‎00

ID des Paketinhaltsanbieters89

Modell-ID77097

Zeit der letzten Aktualisierung des Modells‎06‎.‎11‎.‎2017‎ ‎15‎:‎42‎:‎00

Letzter Aktualisierungsstatus des Modells0

Zeit der nächsten Aktualisierung des Modells‎07‎.‎11‎.‎2017‎ ‎09‎:‎43‎:‎27

UNQUOTE

 

Looking forward to hearing from you.

 

Best,

Christoph Lewening

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    First lets start by understanding how you are putting this data on a map. 

     

    Are you using an entire address, or a set of coordinates?

     

    Have you set your data columns used in this mapping to the Data Categories?  (Found under the Modeling Tab of the ribbon)?

     

    When you have selected your fields for the map, have they set themselves to an aggration unexpectidly?

     

    On that last point, i had some locations set up via Long/Lat coordinates.  The map was using "First" which meant that it took my grouped list, ordered the Long coords and took the first in that order.  It then ordered the Lat coords, and took the first in that order.  This provided a Long and Lat coordinates that came from different line items in my dataset, and provided completely wrong points on the map.