Import data from ssas cube

[MP_123]

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!

[v-sihou-msft]

@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]

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.