Reply
Frequent Visitor
Posts: 8
Registered: ‎11-15-2016
Accepted Solution

Power BI on the iPhone - Will geo location work if report is using data from SSAS live connection?

We use a country dimension Coming from an SSASTabular 'live connection'. When viewing the report on the iPhone app, the geo filter is always greyed out.

Is this because of the live connection?

Link to support document on setting geo filtering. This only shows it can be done in PBI itself. No reference to SSAS. Should SSAS data work?

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-mobile-geofiltering/

Accepted Solutions
Moderator
Posts: 2,588
Registered: ‎03-06-2016

Re: Power BI on the iPhone - Will geo location work if report is using data from SSAS live connectio

@Carmichael01

 

I reproduced same issue as yours. If we create a map with SSAS live connection, the geo filter buttion is always disabled when we access via Power BI Mobile App even it contains the data for my current location (I tested with VPN changing different location nodes). We have reported this issue internally.

 

Regards,

Simon Hou

View solution in original post


All Replies
Moderator
Posts: 93
Registered: ‎03-25-2016

Re: Power BI on the iPhone - Will geo location work if report is using data from SSAS live connectio

Hi,

 

If you mark the country column with the "Country" Data Category (in Power BI desktop) and you have relevant data to the users location, the geo location capability should be available also for SSAS live connections.

See more details here - https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-mobile-geofiltering/

Please contact us if this doesn't work for you.

mpbisup@microsoft.com

 

Thanks,

Gabi

 

Moderator
Posts: 2,588
Registered: ‎03-06-2016

Re: Power BI on the iPhone - Will geo location work if report is using data from SSAS live connectio

@Carmichael01

 

I reproduced same issue as yours. If we create a map with SSAS live connection, the geo filter buttion is always disabled when we access via Power BI Mobile App even it contains the data for my current location (I tested with VPN changing different location nodes). We have reported this issue internally.

 

Regards,

Simon Hou

Moderator
Posts: 93
Registered: ‎03-25-2016

Re: Power BI on the iPhone - Will geo location work if report is using data from SSAS live connectio

Hi,

 

have you marked the relevant column in Power BI Desktop as "Country", "State" or "City".

If you haven't done that the geographical filter will not work.

Creating a map tile is not sufficient to enable the geographical filter on the report.

If this still doesn't work for you, please contact us on mpbisup@microsoft.com with more details.

 

Thanks,

Gabi

Frequent Visitor
Posts: 8
Registered: ‎11-15-2016

Re: Power BI on the iPhone - Will geo location work if report is using data from SSAS live connectio

Thanks Simon - do I need to provide any further info or is your reproduction sufficient for a fix? If resolved will it be updated here?
Frequent Visitor
Posts: 8
Registered: ‎11-15-2016

Re: Power BI on the iPhone - Will geo location work if report is using data from SSAS live connectio

Hi Gabi - the location fields are set as geography type in SSAS Tabular. Given we have a live connection back to our model it isn't possible to manage via Power BI; the setting must be made in SSAS it's self.

Simon has advised that issue can be reproduced and has been raised internally thus I am assuming it's now logged with the PBI team.

Thanks
Moderator
Posts: 93
Registered: ‎03-25-2016

Re: Power BI on the iPhone - Will geo location work if report is using data from SSAS live connectio

Hi,

 

We will log this issue to examine during our planning process.

Thanks for your feedback.

 

Gabi