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.
The QBO Dashboard is handy, but it's interpreting postal codes in Germany as US zip codes in the map labelled Customer/Client Billing City. Yes, the customer records clearly have either "Germany" or "Deutschland" in the address. Why are these being seen as US zip codes? It seems there is no intelligence built in to this as the misinterpreted "zip codes" don't even correspond to the city entry in the customer record. (Zip code "96052" is indeed in California, but not in a city named "Bamberg"; the correct interpretation would be "Bamberg" in Germany in postal code "96052".)
Hi Dofzin,
Thanks for sharing your QB Experience to us. I would also include some information it. When we transder all QuickBooks Online data to Quickbooks desktop this problem does'nt happens. In QuickBooks Online right side there is always a option Contact to our Support or Dial
1-888-771-0476 its a QuickBooks Official Number
@dofzin wrote:
The QBO Dashboard is handy, but it's interpreting postal codes in Germany as US zip codes in the map labelled Customer/Client Billing City. Yes, the customer records clearly have either "Germany" or "Deutschland" in the address. Why are these being seen as US zip codes? It seems there is no intelligence built in to this as the misinterpreted "zip codes" don't even correspond to the city entry in the customer record. (Zip code "96052" is indeed in California, but not in a city named "Bamberg"; the correct interpretation would be "Bamberg" in Germany in postal code "96052".)
What the problemtatic tile are you talking? Could you try to click on the tile and go to the report to see what column is used as the location field and what is the value in the column?
While the problem occurs on ever tile that uses customer data, one example is the tile named Gross Profit by Billing Postal Code and Billing City. The visualization is a map using the fields Billing Postal Code as the Location, Billing City as the Legend (ah, the mistake is clear already!) from the Customer table and also using Gross Profit as the Size from the General Ledger table.
Without including information about the country the customer is located in, it's not possible to correctly map by postal code, and clearly the Billing City is not being used to validate the location of the postal code. Is 96052 a postal code in Germany or the USA? Without context, it's impossible to know, which is why the tile is showing the data in the wrong map location (it is assuming the Billing Postal Code is a US zip code, but in this case it's a German postal code).
I'm grasping at straws here - but you might change the column/field name from 'Billing Country' to 'Country'.... or potentially duplicate that column with the name Country
Would be fast to test. I'm only thinking that PBI is not recognizing the field name in order to then recognize the mail code reference....
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.