Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Power BI Using Adventurers DD in Azure DimGeography not working

Im using the Adventureworks Data Warehouse as a test in Azure and Im trying to create a Map   We have DimGeography joined to DImSalesTerritory and and FactResellerSales joined to DimSalesTerritory ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi DebbieE,

     

    It seems like your relationship not mapping correctly so power bi summarize all records to a static value.

    Can you please share some sample data and relationship map?

    How to Get Your Question Answered Quickly

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi DebbieE,

 

It seems like your relationship not mapping correctly so power bi summarize all records to a static value.

Can you please share some sample data and relationship map?

How to Get Your Question Answered Quickly

 

Regards,

Xiaoxin Sheng

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
7 years ago

Your right, the Geography dimension isnt mapped correctly to the fact table in Adventureworks (Which is odd because this is the sample data warehouse)

 

I wasn thinking that Power BI couldnt cope with looking at data from a fact table and a snowflaked table but I think this isnt the case so its the data set and not Power BI