Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. Some examples: as per this tile, Jersalem is now in Latin America and Switzerland is located around New York etc. .
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 Pakets08.07.2016 18:15:46
Letzter Aktualisierungsstatus des Pakets0
Zeit der nächsten Aktualisierung des Pakets07.11.2017 09:14:00
ID des Paketinhaltsanbieters89
Modell-ID77097
Zeit der letzten Aktualisierung des Modells06.11.2017 15:42:00
Letzter Aktualisierungsstatus des Modells0
Zeit der nächsten Aktualisierung des Modells07.11.2017 09:43:27
UNQUOTE
Looking forward to hearing from you.
Best,
Christoph Lewening
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.