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.