Forum Discussion

BobMcPen's avatar
BobMcPen
Regular Visitor
8 years ago

Map Visualization doesn't work with Analysis Sevices??

(Moved from Developer Forum)   Hi everybody. Looked around but didn't found a solution for this.   my scenario: I have an SSAS cube with a Suppliers dimension. In it i have several fields to ge...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi BobMcPen,

 

First please check the Data Category option of this field at both SQL Server table and SSAS side in Power BI. Choose this filed -> Modeling -> Date Category and verify the difference.

 

 

And could you please share us some sample data if possible?

 

Thanks,
Xi Jin.

BobMcPen's avatar
BobMcPen
Regular Visitor
8 years ago

Hi v-xjiin-msft, thanks for reply and sorry for the delay: in Italy we had some vacations at the end of april...

 

I tried your suggestions: if i query SS table via PowerBI i can change Data Category and whith category 'Place' the map shows well:

while others categories fail. 

 

Then, via SSDT, i tryed several categories for that field, but in PowerBI always show 'uncategorized' (and i can't change it) and the map doesn't showes the location:

Here where i set in SSDT the category:

 

 

Maybe i made any mistake? I deployed the cube each time after modify....

 

My enviroment:

SS 2016 with AS

PowerBI: 2.51.4885.543 64-bit (October 2017)

Visual Studio SSDT: Microsoft SQL Server Integration Services Designer Version 12.0.2430.0

 

Thanks again for your help.