Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
10 years ago

Import data from ssas cube

hi everybody,

 

i'm importing data from a ssas cube and i see there is missing data - i mean

total sum is not the same in the power bi and the DB

is someone have an idea how to solve it?

 

thanks!

Need Help

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    10 years ago

    MP_123

     

    I can't reproduce you issue. In Power BI Desktop, it returns exactly same cube data as I query in SSMS. Make sure you refresh the dataset. Also you can compare the fact data on each detail hierarchy level to see the differece between Power BI and SSMS. Also check if there's any Row Level Security in Power BI Desktop.

     

    Regards,

    • MP_123's avatar
      MP_123
      Microsoft Employee
      10 years ago

      hi v-sihou-msft, thanks for replying!

       

      actually there is no row level security, i think the problem is that there is a large amount of data, and pbi doesn't bring it all.