using a live connection with analysis services to fill maps

[Ofri]

I have an analysis database (multidimensional) with stores and their sales values. The store dimension has the attributes "store", "longitude" and "latitude". In the calculations of the cube I added two measures for the coordinates:

[Measures].[Longitude] as CDbl( [Store].[Store].Properties("Longitude"))

[Measures].[Latitude] as CDbl( [Store].[Store].Properties("Latitude"))

The MDX

select { [Measures].[Longitude], [Measures].[Latitude], [Measures].[Sales Value] } on 0
,[Store].[Store].[Store] on 1
from [Sales]

returns the correct values and types (alle measures are of type double).

How do I visualize the stores on a map in PowerBI-Desktop? How do I configure the properties of a map correctly?

Thanks for help!

[ashishogr]

Any solution to the issue in this thread?? I am facing a similar problem.

[v-huizhn-msft]

Hi @Ofri,

Based on your title, you connect SQL Server Analysis database in live connection mode. As I tested, we can't write MDX(the mdx zone is grey out) when get data in live mode as the following screenshot shows.



If you use the MDX to select data, you will get a table including the following fields.

StoreName	Longitude	Latitude	SalesValues

If my understanding is right, please put StoreName in Location field, Longitude as Longitude, Latitude as Latitude, SalesValue as Size level.

Then you will get a similar map like the following screenshot shows. The SalesValue is bigger, the size of dots are bigger.

Best Regards,
Angelia

[Ofri]

Hi Angelia

I thougt it would work this way. But you can't drop measures into Latitude or Longitude. Is there an example with live data?

Best wishes, Olaf

[v-huizhn-msft]

Hi @Ofri,

As I tested, when we connect data in live mode. We still can't use measure into into Latitude or Longitude. You need to use  into Latitude or Longitude value in the levels.

Best Regards,
Angelia

[Ofri]

Hi Angelia

My last post wasn't correct. It is possible to drop measures into Latitude or Longitude, but you get an error message. I tried with

Map:

ArcGIS:

Filled Map:

I don't see how it would work with "levels". I have dimension properties Latitude and Longitude in level "Store", but I can't use them except as measures. Is there no sample with latitude and longitude?

Thanks for help!

Olaf

[v-huizhn-msft]

Hi @Ofri,

The measure will return one value based on the column field. While in Latitude or Longitude, we need corresponding two columns. Because the pair of columns will determine many points rather than one dot. So it displays the error message.

The data structure like what shown in the following screenshot. And you can get it in google map.



Best Regards,
Angelia

[Ofri]

I try to send you a sample.

[v-huizhn-msft]

Hi @Ofri,

Got it.

Best Regards,
Angelia

[Ofri]

Hi Angelia

You can download a sample from http://ofries.de/powerbi/map.zip. Hope you can see the problem.

Best wishes,

Olaf