Forum Discussion
Connexion mode Analysis Services
Hi guys,
I have a report which retrieves data from a dataset of my workspace by the SQL Server Analysis Services mode
I choose only origine table's column and not its mesures like below
The number of lines in my destination table is not the same than my origine table. Do you know why ?
the origine has 253 990 lines and the destination table has 255 158. As it is a cube, I thought it might be an agregation somewhere but I have done a SUM operation in 2 pbix on the NbAppels( number of calls), it gives me a difference result.
Someone could help me to understand ?
Thank you in advance
1 Reply
limit your issue to just a single table/dimension. See if you can narrow it down to some attributes. Check with the owner of the semantic model - maybe they are frequently refreshing the partitions?
